An Optimizer, Not an Agent: Deterministic, Cost-Based Postgres Tuning

Tuesday, November 24 at 10:25-11:10
Sponsor Sessions Intermediate

Liberatii Advisor isn't an agent calling tuning scripts. Like a query planner, it builds alternative physical designs, prices each by weighing read benefit, write cost, frequency, and network latency, and picks the winner. Keeping the original design is one of the choices it can make. Same inputs, same decision, with full cost evidence.

Two live demos with plain SQL:

  1. Advisor finds a five-join bottleneck, applies safe indexes under live traffic, and verifies the gain at the application.
  2. One query runs three ways across a remote distributed PostgreSQL cluster and a local materialization, showing why remote materialization saves compute but not the WAN round trip.
Back

Join Us For PGConf.PL 2026

24 November 2026

ARCHE Dwór Uphagena, Gdańsk, Poland

Our Sponsors

PgConf.PL would not be possible without our generous sponsors.