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:
- Advisor finds a five-join bottleneck, applies safe indexes under live traffic, and verifies the gain at the application.
- 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.