Part Three: PgBouncer and persistent connections during downtime (This is part three of my technical response to a series of questions about the use of PgBouncer and what you need...
Benchmarking is hard. Benchmarking databases is even harder. Benchmarking databases that follow different approaches (relational vs document) is harder still. But the market demands these kinds of comparisons. Despite the...
The world of the Database Administrator (DBA) has changed since the technology went mainstream in the 1970s, writes Bruce Momjian, co-founder of the PostgreSQL Global Development Group. Over the last...
Highway monitoring solutions provider Costain (formerly Simulation Systems Limited) was building a new system to support vehicular traffic surveillance cameras that monitor tunnels throughout London. Transport for London required constant...
In this article we are going to see how database servers work together to allow the second server to take over quickly if the primary server fails(high availability), and to...
EnterpriseDB is about to announce the release of EnterpriseDB Postgres Advanced Server (EPAS) 11, with lots of new and exciting features. Starting with v11, EnterpriseDB will stop building “1 Click”...
My friend and colleague Bruce Momjian recently shared in his presentation “Will Postgres Live Forever?” an overview of reasons why companies adopt open source software (OSS) in general. This overview...
Being an analytics/reporting product company, we’ve worked with a fair amount of customers who run Postgres/Redshift for their analytics, and the same fair amount who uses MySQL.
There have been a number of articles on the upcoming improvements in Postgres v11, including one by EnterpriseDB’s own Bruce Momjian. A couple of the most commonly highlighted areas are...
In PostgreSQL 11, a new functionality of autoprewarm has been added into the contrib module pg_prewarm. This automatically warms the shared buffers with the same pages held before the last...
