Episode 188 Automatic Indexing | Function Pipelines | With Hold Cursors | Query Scans

<p>In this episode of Scaling Postgres, we discuss automatic indexing, function pipelines, with hold cursors and the different query scans.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.depesz.com/2021/10/22/why-is-it-hard-to-automatically-suggest-what-index-to-create/"> https://www.depesz.com/2021/10/22/why-is-it-hard-to-automatically-suggest-what-index-to-create/</a><br /> <br /> <a href= "https://blog.timescale.com/blog/function-pipelines-building-functional-programming-into-postgresql-using-custom-operators/"> https://blog.timescale.com/blog/function-pipelines-building-functional-programming-into-postgresql-using-custom-operators/</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/with-hold-cursors-and-transactions-in-postgresql/"> https://www.cybertec-postgresql.com/en/with-hold-cursors-and-transactions-in-postgresql/</a><br /> <br /> <a href= "https://arctype.com/blog/postgres-explain-analyze-scan/">https://arctype.com/blog/postgres-explain-analyze-scan/</a><br /> <br /> <a href= "https://postgres.ai/blog/20211018-postgresql-lock-trees">https://postgres.ai/blog/20211018-postgresql-lock-trees</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/postgres-queries-for-projecting-monthly-revenue-run-rate"> https://blog.crunchydata.com/blog/postgres-queries-for-projecting-monthly-revenue-run-rate</a><br /> <br /> <a href= "https://about.sourcegraph.com/blog/postgres-text-search-balancing-query-time-and-relevancy/"> https://about.sourcegraph.com/blog/postgres-text-search-balancing-query-time-and-relevancy/</a><br /> <br /> <a href= "https://elephanttamer.net/?p=68">https://elephanttamer.net/?p=68</a><br /> <br /> <a href= "https://aws.amazon.com/blogs/database/upgrade-amazon-rds-and-amazon-aurora-postgresql-version-9-6/"> https://aws.amazon.com/blogs/database/upgrade-amazon-rds-and-amazon-aurora-postgresql-version-9-6/</a><br /> <br /> <a href= "https://postgresql.life/post/ivan_panche