All Your GUCs in a Row: cursor_tuple_fraction
The planner assumes cursors fetch only 10% of results by default. If you're actually reading them all, that fast-start bias could be killing your performance.
America Forever Bytes
PostgreSQL · AFBytes
Technology
PostgreSQL
Recent coverage
PGConf.PL 2026 Call for Papers Open
The PostgreSQL Conference Poland - [PGConf.PL](https://2026.pgconf.pl/) 2026 - [Call for Papers](https://2026.pgconf.pl/call-for-papers/) is now officially open...
PostgreSQL: PG DATA 2026
PG DATA 2026 Location: Chicago, IL, United States Language: English This event is recognised under the community event guidelines PG DATA 2026 is the first ...
Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using extensions (Bloom, pg_trgm, and pg_bigm)
In Part 1, Part 2, and Part 3 of this series, we explored PostgreSQL’s native indexes (B-tree, GIN, GiST, HASH, BRIN) and specialized extension-based index ty...
Index types supported in Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL using extensions (SP-GiST, Btree_Gin and Btree_Gist)
In this post, the third in the series, we dive into three extension-based index types: SP-GiST, btree_gin, and btree_gist. These are available in Amazon Aurora ...
Why migrating from Oracle is harder than anyone admits – and what you should do instead
Oracle-to-Postgres migrations routinely go over budget — not because of schemas, but because of DBMS_* packages. Learn what breaks, why automated tools miss i...
All Your GUCs in a Row: createrole_self_grant
PostgreSQL 16 overhauled role management to tame the near-superuser power of CREATEROLE.
pg_stat_statements: everything it tells you
What pg_stat_statements records and what it quietly drops: the queryid jumble that splits one query into many rows, the frozen first-seen query text, and averag...
Robert Haas: Hacking Workshop for June
I was hoping to usual resume the monthly cadence of hacking workshops in June, but it didn't quite happen, largely due to being a little exh...
Managed Postgres, Examined: Azure Database for PostgreSQL Flexible Server
Azure's managed PostgreSQL differs from competitors by putting the standby in the commit path—every write waits for synchronous replication to a second server...
The Night Our Tables Wouldn't Stop Growing
PostgreSQL logical replication can silently fail when statement_timeout interrupts the initial sync. Here’s what happened, why tables ballooned, and how to pr...
All Your GUCs in a Row: cpu_index_tuple_cost, cpu_operator_cost, and cpu_tuple_cost
cpu_tuple_cost, cpu_index_tuple_cost, and cpu_operator_cost are three of the constants the planner uses to price a query, and the single most useful thing to kn
Accelerating developer productivity in the agentic AI era with Amazon Aurora PostgreSQL
In this post, you learn how Amazon Aurora PostgreSQL-Compatible Edition accelerates developer productivity in the agentic AI era. We explore three core design c...
Database Indexing Mistakes That Senior Java Developers Still Make in 2026: A Deep Dive With PostgreSQL and Hibernate
Senior Java developers still make six critical database indexing mistakes in 2026. This deep dive covers how Hibernate 6's new SQL generation
All Your GUCs in a Row: compute_query_id
PostgreSQL 14 unified query-id computation across all subsystems, but defaulting to always-on would tax every backend.
Absurd
Absurd is a Postgres-native durable workflow system built around durable execution in PostgreSQL.
Open-Source TDE for PostgreSQL: What pg_tde Is, and Whether You Need It
PostgreSQL finally has an open-source Transparent Data Encryption option.
How data scientists work with PostgreSQL from Python (and how to write queries that don’t break at scale)
Learn how PostgreSQL powers data science workflows, including query execution, performance optimization, indexing, data retrieval, and more.
PGConf.dev 2026: Our team’s sessions, working groups, and key takeaways
Read about our team's key contributions and takeaways from PGConf.dev 2026. Insights on PostgreSQL, community onboarding, extension ecosystem, and more.
All Your GUCs in a Row: commit_timestamp_buffers
PostgreSQL 17 made SLRU buffer pools configurable for the first time.
Percona Operator for PostgreSQL 3.0.0: Hard Fork, OLM Scoping, Major Upgrades
Meta description: Percona Operator for PostgreSQL 3.0.0 completes the hard fork from Crunchy PGO with a renamed CRD group enabling coexistence with the Crunchy ...