Improving UPDATE query performance using Heap-Only Tuples (HOT) Heap-Only Tuples allow a significant boost in UPDATE query performance allowing businesses to scale their PostgreSQL for critical data. Read More
A look at PostgreSQL’s journey over 5 years in Stack Overflow’s Developer Survey A look at 5 year trends of database popularity, focusing on PostgreSQL, based on Stack Overflow's annual developer survey Read More
Data inconsistency in highly available PostgreSQL clusters If nodes in a database cluster get out of sync, the inconsistency can cause data corruption. This blog describes what to watch out for. Read More
Disruptions caused by false alarms in highly available PostgreSQL clusters False alarms can be a significant problem in highly available clusters of PostgreSQL. They can cause unnecessary downtime and disruptions that can impact the performance of the nodes. Read More
pg_stat_statement – Benefits and Shortcomings [PGSQL Phriday #008] pg_stat_statement is the essential extension that provides valuable insights into the query performance of a PostgreSQL database. Read More