Re: Searching for paper about pg's optimizer cost model

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Bausch <DanielBausch(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Searching for paper about pg's optimizer cost model
Date: 2010-05-28 13:54:45
Message-ID: 24519.1275054885@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Daniel Bausch <DanielBausch(at)gmx(dot)de> writes:
> does anybody know a paper (or any document but the code itself) containing a
> description of the current cost model used by the query optimizer/planner.

If you look on the project website you can find slides from various
conference presentations that give overviews of the planner. But if you
want details you'll have to read the code. It's at least moderately
well commented, though. Most of the skeletons in this particular
closet are in costsize.c and selfuncs.c.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jacqui Caren-home 2010-05-28 14:02:36 subscribe
Previous Message zhenyang guo 2010-05-28 13:41:38 hi,for help!