Re: query optimizer - Mailing list pgsql-general

From Tom Lane
Subject Re: query optimizer
Date
Msg-id 20230.1184991670@sss.pgh.pa.us
Whole thread Raw
In response to Re: query optimizer  (Luca Ferrari <fluca1978@infinito.it>)
Responses Re: query optimizer  (Luca Ferrari <fluca1978@infinito.it>)
List pgsql-general
Luca Ferrari <fluca1978@infinito.it> writes:
>> src/backend/optimizer/README

> I've read this yesterday, very interesting, but I'm looking for something
> similar related to geqo. I mean, is there any presentation/demo that
> step-y-step explains how geqo could take decisions?

There's not a lot, but I just made a few improvements here and here:
http://developer.postgresql.org/pgdocs/postgres/planner-optimizer.html
http://developer.postgresql.org/pgdocs/postgres/geqo-pg-intro.html

Beyond that, the GEQO chapter provides several references, and IMHO
you should not be all that resistant to looking into the source code.
Even if you don't read C well, many of the files provide a wealth of
info in the comments.

            regards, tom lane

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Foreign key constraint question
Next
From: "Josh Tolley"
Date:
Subject: Re: Difference between PRIMARY KEY index and UNIQUE-NOT NULL index