A long time ago, in a galaxy far far away, threads' were a programming novelty rarely used and seldom trusted. In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed, after all. Since then, a lot of water has flown under that bridge, but the PostgreSQL … [Read more...] about PostgreSQL Connection Pooling: Part 1 Pros & Cons
sql
PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types
PostgreSQL popularity is skyrocketing in the enterprise space. As this open-source database continues to pull new users from expensive commercial database management systems like Oracle, DB2 and SQL Server, organizations are adopting new approaches and evolving their own to maintain the exceptional performance of their SQL deployments. We recently attended the PostgresConf … [Read more...] about PostgreSQL Trends: Most Popular Cloud Providers, Languages, VACUUM, Query Management Strategies & Deployment Types
Which Is the Best PostgreSQL GUI? 2019 Comparison
PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. In this post, we discuss the top 5 GUI tools for administering your PostgreSQL deployments. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. The … [Read more...] about Which Is the Best PostgreSQL GUI? 2019 Comparison
Managing High Availability in PostgreSQL Part III: Patroni
In our previous blog posts, we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by Cluster Labs and Replication Manager (repmgr) by 2ndQuadrant. In the final post of this series, we will review the last solution, Patroni by Zalando, and compare all three at the end so you can determine which high availability framework is best for your … [Read more...] about Managing High Availability in PostgreSQL Part III: Patroni
MySQL High Availability Framework Explained Part III: Failover Scenarios
In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability. MySQL Failover Scenarios Scenario 1 “ Master MySQL … [Read more...] about MySQL High Availability Framework Explained Part III: Failover Scenarios
