Idle Transactions Cause Table Bloat? Wait, What?

What Is Table Bloat?Table bloat in PostgreSQL occurs when unused or outdated data, known as dead tuples, accumulates in tables and indexes. PostgreSQL uses aMulti-Version Concurrency Control (MVCC)mec...

PostgreSQL 16 Logical Replication Improvements in Action

The blog will focus on the parallel apply and binary copy features in PostgreSQL 16. The parallel apply feature enables the functionality of using parallel background workers at the subscriber node fo...

How to speed up SQL queries while keeping SQL clean?

In this article, we will discuss how to increase the speed of SQL queries while still keeping SQL statements concise. Before we get into the topic, let's take a look at how queries are actually pr...

DELETE is hard.

Your database is running fine - until a simple DELETE operation crashes it. What went wrong? While we tend to focus on optimizing SELECT and INSERT operations,we often overlook the hidden complexities...

How to optimize queries for date ranges in PostgreSQL?

Queries dealing with date ranges are common operations in PostgreSQL. However, without proper optimization, these queries can cause performance problems, especially when working with large datasets. T...

Postgres Queries

Hope these queries can also help you in your day to day quest to make Postgres run better!The first three queries rank top SQL from pg_stat_statements either by execution count, mean_exec_time and tot...