February 4, 2024 · 11:15 am
↓ Jump to Comments

Tuning Parameters vs Tuning Queries: presentation and recording

This talk was presented at Chicago PUG in January; it was a reserved talk for FOSDEM, so I held off with sharing until after the conference. Now that the conference is over, here is it!

tuning_parameters_queriespptxDownload

2 Comments

Filed under talks

Tagged as ,

2 responses to “Tuning Parameters vs Tuning Queries: presentation and recording”

  1. teampgmustardcom
    February 6, 2024 at 12:20 pm

    Great talk Hettie!

    Sadly, random_page_cost is still 4.0 by default[0] as of Postgres 16. More managed service providers are now changing it to lower values like the 1.1 you mentioned, which is good at least, but I’d love to see it changed in core too.

    [0]: https://www.postgresql.org/docs/16/runtime-config-query.html#GUC-RANDOM-PAGE-COST

    Reply
  2. Hettie D.
    February 6, 2024 at 12:23 pm

    Thank you! Was it changed back to 4? I was sure that I saw 1.1 at some point!

    Reply

Leave a comment