Conserving CPU's cycles ... · Scour

Andrei Lepikhov: Finding invisible use-after-free bugs in the PostgreSQL planner

danolivo.substack.com·3w·Substack

Andrei Lepikhov: 500 Milliseconds on Planning: How PostgreSQL Statistics Slowed Down a Query 20 Times Over

danolivo.substack.com·15w·Substack

Andrei Lepikhov: Inventing A Cost Model for PostgreSQL Local Buffers Flush

danolivo.substack.com·18w·Substack

Andrei Lepikhov: Revising the Postgres Multi-master Concept

danolivo.substack.com·30w·Substack

Andrei Lepikhov: Extra approach to RTABench Q0 optimisation

danolivo.substack.com·40w·Substack

Andrei Lepikhov: Squeezing out Postgres performance on RTABench Q0

danolivo.substack.com·40w·Substack

On Postgres Plan Cache Mode Management

danolivo.substack.com·45w·Substack

On expressions' reordering in Postgres

danolivo.substack.com·55w·Substack

Boosting Postgres' EXPLAIN

danolivo.substack.com·57w·Substack

Automated Management of Extended Statistics in PostgreSQL

danolivo.substack.com·61w·Substack

Does Postgres need an extension of the ANALYZE command?

danolivo.substack.com·66w·Substack

Whose optimisation is better?

danolivo.substack.com·69w·Substack

Investigating Memoize's Boundaries

danolivo.substack.com·71w·Substack

Fractional Path Issue in Partitioned Postgres databases

danolivo.substack.com·73w·Substack

Could GROUP-BY clause reordering improve performance?

danolivo.substack.com·76w·Substack

PostgreSQL 'VALUES -> ANY' transformation

danolivo.substack.com·84w·Substack

Postgres query re-optimisation in practice

danolivo.substack.com·90w·Substack

Probing indexes to survive data skew in Postgres

danolivo.substack.com·91w·Substack

Does PostgreSQL respond to the challenge of analytical queries?

danolivo.substack.com·92w·Substack

Designing a Prototype: Postgres Plan Freezing

danolivo.substack.com·93w·Substack

Log in to enable infinite scrolling