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

Re: About method of PostgreSQL's Optimizer

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pryscila(dot)lista(at)gmail(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: About method of PostgreSQL's Optimizer
Date: 2005-09-13 23:23:02
Message-ID: 43275F56.8020303@commandprompt.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Pryscila B Guttoski wrote:
> Hello all!
> 
> On my master course, I'm studying the PostgreSQL's optimizer.
> I don't know if anyone in this list have been participated from the 
> PostgreSQL's Optimizer development, but maybe someone can help me on 
> this question.
> PostgreSQL generates all possible plans of executing the query (using an 
> almost exhaustive search), then gives a cost to each plan and finally 
> the cheapest one is selected for execution.
> There are other methods for query optimization, one of them is based on 
> plan transformations (for example, using A-Star algorithm) instead of 
> plan constructions used by PostgreSQL.
> Does anyone know why this method was choosen? Are there any papers or 
> researches about it?

You may want to pass this question over to pgsql-hackers.

Sincerely,

Joshua D. Drake


> 
> Thank's a lot,
> Pryscila.


-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

In response to

pgsql-performance by date

Next:From: Cristian PrietoDate: 2005-09-13 23:31:54
Subject: Re: About method of PostgreSQL's Optimizer
Previous:From: Neil ConwayDate: 2005-09-13 23:16:26
Subject: Re: About method of PostgreSQL's Optimizer

pgsql-hackers by date

Next:From: Cristian PrietoDate: 2005-09-13 23:31:54
Subject: Re: About method of PostgreSQL's Optimizer
Previous:From: Neil ConwayDate: 2005-09-13 23:16:26
Subject: Re: About method of PostgreSQL's Optimizer

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