A PostgreSQL Database Failure and a Failover A customer reached out to the Support team on a random Tuesday, some months ago. They had experienced a failure of their primary...
A typical database-oriented application setup only must work with single operation SQL or RESTful execution. Your customers might only be sending the INSERT or UPDATE queries one at a time...
PostgreSQL has json support – but you shouldn’t use it for the great majority of what you’re doing. This goes for hstore too, and the new jsonb type. These types...
This week, a customer I was working with wanted help setting wal_keep_segments—the number of extra transaction log files to keep on the primary specifically so that standbys could afford to...
A corruption in the database base often manifests itself in the form of errors when performing a DDL or DML operation on affected relations. The errors often show up as...
This blog is part of a series that will discuss best practices for High Availability (HA) for Postgres databases. In a prior blog, I explained what High Availability means (...
This article discusses how to perform benchmark tests using the open source tool, HammerDB, as an alternative to using pgbench. We will review: Hardware specifications Operating system configurations PostgreSQL configurations...
With the ongoing crisis of COVID-19, I keep myself updated with the latest situation around the globe. The WHO’s website is one I’ve used frequently—and even there I began to...
Welcome to this week’s Postgres Pulse Insights, where we answer vital Postgres questions and provide key tactics for DBAs on how to overcome common database hurdles. Let’s jump right in...
There is no question that PostgreSQL adoption is increasing exponentially. Organizations of all sizes are deploying PostgreSQL for a variety of database workloads. As a result, you can find PostgreSQL...