{"type":"rich","version":"1.0","provider_name":"Transistor","provider_url":"https://transistor.fm","author_name":"Postgres FM","title":"Query hints","html":"<iframe width=\"100%\" height=\"180\" frameborder=\"no\" scrolling=\"no\" seamless src=\"https://share.transistor.fm/e/792af68e\"></iframe>","width":"100%","height":180,"duration":2138,"description":"Nikolay and Michael discuss query hints — what they are, what we do and don't have in PostgreSQL, and some other things in and around the ecosystem to be aware of. \n \nHere are some links to some extra things they mentioned:\nQuery planning (docs) https://www.postgresql.org/docs/current/runtime-config-query.html \nStatistics used by the planner (docs) https://www.postgresql.org/docs/current/planner-stats.html \ndefault_statistics_target  https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-DEFAULT-STATISTICS-TARGET \nOptimiser hints discussion (wiki) https://wiki.postgresql.org/wiki/OptimizerHintsDiscussion  \nAn example mailing list thread from 2006 https://www.postgresql.org/message-id/flat/20061012151439.GT28647%40nasby.net  \nPeter Geoghegan tweet regarding invalid index https://twitter.com/petervgeoghegan/status/1599191964045672449 \nplantuner http://sigaev.ru/git/gitweb.cgi?p=plantuner.git;a=blob;hb=HEAD;f=README.plantuner\npg_hint_plan https://github.com/ossc-db/pg_hint_plan \nAurora PostgreSQL query plan management https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Optimize.overview.html \nBuilding automatic adviser & performance tuning tools - Julien Rouhaud & Tatsuro Yamada: PGCon 2020 (the completely misremembered presentation Michael mentioned 🙈) https://www.youtube.com/watch?v=LQZK6p3SwwA \nhypopg https://github.com/HypoPG/hypopg \n\n~~~\nWhat did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!\n\n~~~\nPostgres FM is brought to you by:\nNikolay Samokhvalov, founder of Postgres.ai\nMichael Christofides, founder of pgMustard\nWith special thanks to:\nJessie Draws for the amazing artwork ","thumbnail_url":"https://img.transistorcdn.com/NFbJlGhGV5mzIU1kM0iZ823A69pjZUNX40LszVO5LKI/rs:fill:0:0:1/w:400/h:400/q:60/mb:500000/aHR0cHM6Ly9pbWct/dXBsb2FkLXByb2R1/Y3Rpb24udHJhbnNp/c3Rvci5mbS9zaG93/LzMyMTQ3LzE3MTA3/OTEzODMtYXJ0d29y/ay5qcGc.webp","thumbnail_width":300,"thumbnail_height":300}