Re: [PERFORM] About method of PostgreSQL's Optimizer

2005-09-13 Thread Pryscila B Guttoski
Hi guys, I really appreciate your suggestions abouts papers, specially this one: http://citeseer.csail.mit.edu/371707.html I found some answers on it, like this: Q: Why the main query planner uses a nearly-exhaustive search? A: (Page 20 - 4.2.2) ... up to about ten joins, dynamic programming is

Re: [PERFORM] About method of PostgreSQL's Optimizer

2005-09-13 Thread Tom Lane
Neil Conway <[EMAIL PROTECTED]> writes: > Pryscila B Guttoski wrote: >> 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. >

Re: [PERFORM] About method of PostgreSQL's Optimizer

2005-09-13 Thread Neil Conway
Cristian Prieto wrote: Anyway, do you know where could I get more info and theory about database optimizer plan? (in general) Personally I like this survey paper on query optimization: http://citeseer.csail.mit.edu/371707.html The paper also cites a lot of other papers that cover specific

Re: [PERFORM] About method of PostgreSQL's Optimizer

2005-09-13 Thread Pryscila B Guttoski
Thank's guys! I'll send to pgsql-hackers... []'s PryscilaOn 9/13/05, Neil Conway <[EMAIL PROTECTED]> wrote: Pryscila B Guttoski wrote:> 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 develop

Re: [PERFORM] About method of PostgreSQL's Optimizer

2005-09-13 Thread Cristian Prieto
? (in general) I like that topic, thanks a lot man! - Original Message - From: Pryscila B Guttoski To: pgsql-performance@postgresql.org Sent: Tuesday, September 13, 2005 4:50 PM Subject: [PERFORM] About method of PostgreSQL's Optimizer Hello all!On my m

Re: [PERFORM] About method of PostgreSQL's Optimizer

2005-09-13 Thread Joshua D. Drake
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

Re: [PERFORM] About method of PostgreSQL's Optimizer

2005-09-13 Thread Neil Conway
Pryscila B Guttoski wrote: 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. pgsql-hackers might be more appropriate. PostgreSQL

[PERFORM] About method of PostgreSQL's Optimizer

2005-09-13 Thread Pryscila B Guttoski
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