Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

Next:From: Jacqui Caren-homeDate: 2010-05-28 14:02:36
Subject: subscribe
Previous:From: zhenyang guoDate: 2010-05-28 13:41:38
Subject: hiļ¼Œfor help!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group