PostgreSQL benefits and challenges: A snapshot


The database market continues to be splintered among open source and commercial products, with multiple options in each camp. PostgreSQL, a three-decades-old, community-supported open source project, continues to gain in popularity and is used in production by large enterprises in many parts of the world.

Yandex, for example, stores petabytes of data in PostgreSQL, which enables the company’s email service to handle more than 150 million emails a day. GitLab, which has been using Postgres for years, maintains a large cluster that handles 181,000 transactions per second. IKEA, which moved to PostgreSQL to reduce its total cost of ownership (TCO), has a number of databases running multiple terabytes of data.

[ Also on InfoWorld: The year of PostgreSQL is every year ]

Finally, InCountry, a startup helping international digital businesses comply with local laws in more than a hundredcountries, uses Postgres to power its data-residency-as-a-service global distributed database. It’s an advanced and complicated solution requiring a mature and reliable database management system.

To understand if PostgreSQL is the right database for your projects, it is essential to understand how it fits into the database landscape, as well as its specific benefits and challenges.

The benefits of PostgreSQL

A number of characteristics and features of Postgres make it appropriate for a very wide range of applications:

Copyright © 2021 IDG Communications, Inc.



Source link