How do PostgreSQL's VACUUM optimizations affect dead tuple metrics? Find out why they might persist or reappear when using VACUUM.
cursor_tuple_fraction and the PostgreSQL JDBC driver
by
Laurenz Albe |
05.2024A little failure story about the parameter cursor_tuple_fraction and how it interacts with the PostgreSQL JDBC driver.
Enforcing join orders in PostgreSQL
PostgreSQL handle joins & especially join orders? Internally the PostgreSQL does a good job to optimize queries but how does it really work?
