Search: [optimizer] - Anayrat links

https://danolivo.substack.com/p/could-group-by-clause-reordering

PostgreSQL · optimizer · sort · group_by · planner

November 26, 2024 at 5:11:38 PM GMT+1 * · permalink

https://danolivo.substack.com/p/could-group-by-clause-reordering

Postgres Planner Quirks: JOIN Equivalence Classes and IN/ANY filters

PostgreSQL · planner · Join · optimizer

September 12, 2024 at 10:51:22 PM GMT+2 * · permalink

https://pganalyze.com/blog/5mins-postgres-planner-join-equivalence-class-in-any-filters

Making a Postgres query 1,000 times faster - Mattermost

Row Constructor Comparison

https://dba.stackexchange.com/questions/241591/postgres-choosing-a-filter-instead-of-index-cond-when-or-is-involved

TL;DR : x > a OR (x == a AND y > b) to (x, y) > (a, b)

PostgreSQL · optimizer · Tricks · SQL · not_read · row

May 18, 2024 at 9:24:54 PM GMT+2 * · permalink

https://mattermost.com/blog/making-a-postgres-query-1000-times-faster/

What’s new in the Postgres 16 query planner / optimizer

PostgreSQL · planner · optimizer · pg16

February 8, 2024 at 9:01:26 PM GMT+1 * · permalink

https://www.citusdata.com/blog/2024/02/08/whats-new-in-postgres-16-query-planner-optimizer/

Subqueries and performance in PostgreSQL - CYBERTEC

PostgreSQL · SQL · exists · optimizer

July 11, 2023 at 11:47:17 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/subqueries-and-performance-in-postgresql/

5mins of Postgres E45: IN lists vs ANY operator: Bind parameters and performance

PostgreSQL · IN · optimizer · pg14

November 24, 2022 at 9:44:31 PM GMT+1 * · permalink

https://pganalyze.com/blog/5mins-postgres-performance-in-lists-vs-any-operator-bind-parameters

Fixing Slow PostgreSQL Queries: How to Make a Smart Optimizer More Stupid

ORDER BY a + 0

PostgreSQL · optimizer · Tricks

August 30, 2022 at 10:03:54 PM GMT+2 * · permalink

https://ottertune.com/blog/how-to-fix-slow-postgresql-queries

Queries in PostgreSQL. Index scan / Habr

PostgreSQL · SQL · index · optimizer · planner

May 24, 2022 at 7:44:46 PM GMT+2 * · permalink

https://habr.com/en/company/postgrespro/blog/666974/

Postgres Query Optimization: LEFT JOIN vs UNION ALL

PostgreSQL · Tricks · optimizer · SQL

May 22, 2022 at 10:51:16 PM GMT+2 * · permalink

https://www.crunchydata.com/blog/postgres-query-optimization-left-join-vs-union-all

Robert Haas: Talking about the PostgreSQL Optimizer at CMU

PostgreSQL · Internal · optimizer · planner · SQL

June 22, 2021 at 9:32:20 PM GMT+2 * · permalink

http://rhaas.blogspot.com/2021/06/talking-about-postgresql-optimizer-at.html

The Volcano/Cascades Optimizer

volcano · optimizer · cascade · database

May 31, 2021 at 6:28:46 PM GMT+2 * · permalink

https://fr.slideshare.net/ssuser9ebf46/the-volcanocascades-optimizer

From hours to seconds. SQL Query Optimization using Volcano | by Gaurav Sehgal | Medium

database · volcano · optimizer

May 31, 2021 at 5:57:48 PM GMT+2 * · permalink

https://gaurav-sehgal.medium.com/from-hours-to-seconds-sql-query-optimization-using-volcano-ee7aeff7d77

Bottom-up Join Enumeration in a Top-down Optimizer

Greenplum · orca · optimizer · planner · PostgreSQL · not_read

May 15, 2020 at 9:22:10 AM GMT+2 * · permalink

https://greenplum.org/bottom-up-join-enumeration-in-a-top-down-optimizer/

An Overview of Query Optimization in Relational Systems

not_read · Research · database · optimizer

February 5, 2020 at 2:30:20 PM GMT+1 * · permalink

https://www.microsoft.com/en-us/research/wp-content/uploads/2016/02/pods98-tutorial.pdf

The Cascades Framework for Query Optimization

not_read · Research · database · optimizer

February 5, 2020 at 2:29:40 PM GMT+1 * · permalink

https://www.cse.iitb.ac.in/infolab/Data/Courses/CS632/Papers/Cascades-graefe.pdf

Inside the PostgreSQL Query Optimizer

PostgreSQL · Internal · hack · planner · optimizer

February 14, 2019 at 12:37:20 PM GMT+1 * · permalink

http://www.neilconway.org/talks/optimizer/optimizer.pdf

Double negative and query performance – Alexey Bashtanov PostgreSQL Blog

PostgreSQL · planner · optimizer

October 23, 2018 at 6:53:29 PM GMT+2 * · permalink

https://pgblog.bashtanov.com/2017/12/08/double-negative-and-query-performance/

Index creation can make SELECT performance worse - Cybertec

PostgreSQL · optimizer · index

June 12, 2018 at 8:20:34 AM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/index-decreases-select-performance/

PostgreSQL Query optimization, step by step

PostgreSQL · optimizer · Performance · sql · CTE · RECURSIVE · index · loose_index_scan

March 20, 2018 at 2:18:54 PM GMT+1 * · permalink

https://www.postgresql.eu/events/nordicpgday2018/sessions/session/1858/slides/68/query-optimization-techniques_talk.pdf

PostgreSQL: Speeding up analytics and windowing functions

PostgreSQL · optimizer · Window_function · Performance · sql

March 19, 2018 at 1:16:19 PM GMT+1 * · permalink

https://www.cybertec-postgresql.com/en/postgresql-speeding-up-analytics-and-windowing-functions/