A PostgreSQL Hot Update study on small tables. Fillfactor and Hash Partitioning Strategies.
Benchmark comparing PostgreSQL HOT updates, fillfactor 50, and hash partitioning, with observations and limits for production tuning.
About me
Emanuel Calvo
Database & Storage Infrastructure Engineer
I’m a Staff Infrastructure Engineer at Workato, working on database and storage platforms. I write about PostgreSQL, distributed systems, performance, and reliability.
Based in Madrid, born in Argentina. You may also know me as 3manuek or Tresma.
Latest articles
Upgrading Postgres Major, and Django model with Logical Replication.
A case study using PostgreSQL logical replication for an Aurora major version upgrade alongside a Django model migration with downtime constraints.
Online Backups with no archives in PGBackRest
Even tho is not documented in the official documentation, it is possible to avoid storing archives on PGBackRest setups. In certain scenarios, you may want to disregard storing archives for reducing costs, specially if you are using cloud …
Evaluating PGCat's Sharding by hash
ℹ️ PGCat’s sharding feature is currently experimental. The code for the laboratory can be found at lab_pgcat. PGCat sharding mechanisms As of today, PGCat supports 2 mechanisms of sharding through extended syntax: By setting the shard …
[BabelfishPG] Enabling Statements Execution Time logging and Plans
Introduction ℹ️ Laboratory for this post can be found at babelfishpg-lab. ⚠️ In this post, we cover 4.2.0 version. There is a slight difference in the logging settings and format from 4.1.1. Even tho BabelfishPG is a Postgres flavor, …
Cascading timeouts through Pool (PGBouncer)
How PgBouncer query_timeout and PostgreSQL statement_timeout interact, and what to consider when configuring timeouts for different workloads.
[BabelfishPG] Using tds_fdw to access BabelfishPG
It supports TDS, right? Some things happen once in a lifetime, and the story around this is quite particular. A customer required something that at the beginning sound counter intuitive: migrate an existing Postgres database to BabelfishPG. …