Search: [planner] - Anayrat links

PostgreSQL planner development and debugging - DEV Community

PostgreSQL · planner · hack · Internal · not_read

February 12, 2025 at 11:45:35 AM GMT+1 * · permalink

https://dev.to/ashenblade/postgresql-planner-development-and-debugging-47mc

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

Improve selectivity estimation for assorted match-style operators.

PostgreSQL · Internal · planner · pg13

May 19, 2024 at 10:30:30 AM GMT+2 * · permalink

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=a80818605e5447b9b846590c3d3fab99060cb53e

Understand PostgreSQL's Planner - Simple Scan Paths vs Plans - Highgo Software Inc.

PostgreSQL · planner · Internal

March 23, 2024 at 12:35:40 PM GMT+1 * · permalink

https://www.highgo.ca/2024/03/22/understand-postgresqls-planner-simple-scan-paths-vs-plans/

Out of range planner statistics and "get_actual_variable_range" in Postgres

PostgreSQL · planner · get_actual_variable_range

February 16, 2024 at 7:59:12 PM GMT+1 * · permalink

https://pganalyze.com/blog/5mins-postgres-out-of-range-planner-statistics

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/

A Comprehensive Overview of PostgreSQL Query Processing Stages - Highgo Software Inc.

PostgreSQL · Internal · planner · hack

February 2, 2024 at 4:02:59 PM GMT+1 * · permalink

https://www.highgo.ca/2024/01/26/a-comprehensive-overview-of-postgresql-query-processing-stages/

Exploring a Postgres query plan | notes.eatonphil.com

PostgreSQL · Internal · hack · Extension · planner

November 19, 2023 at 10:23:13 PM GMT+1 * · permalink

https://notes.eatonphil.com/2023-11-19-exploring-a-postgres-query-plan.html

Join order: how to force it in PostgreSQL - CYBERTEC

PostgreSQL · Join · planner

May 4, 2023 at 1:38:01 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/forcing-a-join-order-in-postgresql/

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: on performance of prepared statements with partitioning

PostgreSQL · partionning · partition_pruning · prepare · planner

May 17, 2022 at 10:32:17 AM GMT+2 * · permalink

https://amitlan.com/2022/05/16/param-query-partition-woes.html

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

GitHub - kryonix/pg_cuckoo: Use PostgreSQL's planner hook to open a side entrance through which we can pass plan trees for immediate execution

PostgreSQL · hack · Internal · planner

May 28, 2020 at 3:58:57 PM GMT+2 * · permalink

https://github.com/kryonix/pg_cuckoo

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/

Intro to Postgres Planner Hacking

planner · PostgreSQL · Internal

May 30, 2019 at 8:00:39 PM GMT+2 * · permalink

https://github.com/melanieplageman/debugging_planner/

PostgreSQL v12 new feature: optimizer support for functions - Cybertec

PostgreSQL · planner

May 12, 2019 at 8:47:36 PM GMT+2 * · permalink

https://www.cybertec-postgresql.com/en/optimizer-support-functions/

Debugging the Postgres query planner — GoCardless Blog

PostgreSQL · planner · Statistics

March 4, 2019 at 4:17:06 PM GMT+1 * · permalink

https://gocardless.com/blog/debugging-the-postgres-query-planner/

How Well a Query Optimizer Handles Subqueries? – Striving for Optimal Performance

PostgreSQL · planner

February 21, 2019 at 11:19:49 AM GMT+1 * · permalink

https://antognini.ch/2017/12/how-well-a-query-optimizer-handles-subqueries/

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