Challenges of managing PostgreSQL

PostgreSQL’s popularity is growing and we’ve got the numbers to prove it: this database is currently ranked #4 in popularity amongst hundreds of databases worldwide in the DB-Engines Ranking. Yaniv Yehuda, CTO at DBmaestro weighs in on the challenges of managing PostgreSQL and talks about the factors driving the increased interest in PostgreSQL.

PostgreSQL is becoming the preferred database for more and more enterprises and smaller organizations. It is currently ranked #4 in popularity amongst hundreds of databases worldwide according to the DB-Engines Ranking.

What is even more impressive, is its significant climbing trend in the market (mentions websites, searches, technical discussions, job offers, social networks etc.).

Factors driving the increased interest in PostgreSQL

There are several factors driving the increased interest in PostgreSQL. Many organizations are looking for open source alternatives beyond traditional vendors in the database arena, such as Oracle, Microsoft, and IBM to keep down the total cost of ownership.

PostgreSQL also has the advantage that it can store structured and unstructured data in a single product. Unstructured data, found in audio, video, emails and social media postings, can be used to improve customer service, discover new product requirements, and find ways to prevent a customer from churning in addition to countless other uses. By 2025, IDG projects that 80% of data will be unstructured.

PostgreSQL also has superior online transaction processing capabilities (OLTP) and can be configured for automatic failover and full redundancy, making it suitable for financial institutions and manufacturers. As a highly capable analytical database it can be integrated effectively with mathematical software, such as Matlab and R. Due to PostgreSQL’s replication capabilities, websites can easily be scaled out to as many database servers as you need.

DBmaestro chose to focus on PostgreSQL not just for its obvious popularity and market demand, but also for the challenges it presents to companies using it. Whereas traditional database vendors or 3rd party vendors complete the offering for missing or less than satisfactory supporting tools (just see the ecosystem around Oracle’s database), the PostgreSQL community does not have the luxury of a mature database ecosystem. In addition, PostgreSQL is often used in tandem with several different databases, such as Oracle or MongoDB, where each database requires specialized and somewhat expertise.

DevOps teams and database professionals in addition to management tools for PostgreSQL, also need to be able to manage multiple databases from multiple vendors without having to change existing processes. DBmaestro experience the demand for an overarching solution for CI/CD adoption across platforms and operating systems including Oracle, DB2, Microsoft SQL Server and PostgreSQL, enables organizations to meet the evolving database release automation needs of enterprises across databases for all types of data.

Be the first to share this article with your network!

Author

Yaniv Yehuda

Yaniv is Co-Founder and CTO of DBmaestro. Yaniv is also the Co-Founder and the head of development for the Extreme group, a leading IT services solutions provider group that employs more than 200 IT professionals and serves more than 50 of the largest enterprises in Israel. Prior to DBmaestro, Yaniv was a Co-founder of byUman Inc., an innovative solution for managing web-enabled contact centers.