Re: [PERFORM] GROUP BY Vs. Sub SELECT

On Mon, Apr 24, 2006 at 12:07:39PM -0700, Richard Broersma Jr wrote: > > > I'd like to get more info on EXPLAIN ANALYZE output... where can I read more > > about it? > > I believe this link has what you are looking for: > http://www.postgresql.org/docs/8.1/interactive/performance-tips.html http:

Re: [PERFORM] GROUP BY Vs. Sub SELECT

> I'd like to get more info on EXPLAIN ANALYZE output... where can I read more > about it? I believe this link has what you are looking for: http://www.postgresql.org/docs/8.1/interactive/performance-tips.html Regards, Richard Broersma Jr. ---(end of broadcast)

Re: [PERFORM] GROUP BY Vs. Sub SELECT

output... where can I read more about it? Thank you very much for your attention!! Regards, Bruno -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED] Sent: Sunday, April 23, 2006 8:34 PM To: Bruno Almeida do Lago Cc: pgsql-performance@postgresql.org Subject: Re: [PERFORM] G

Re: [PERFORM] GROUP BY Vs. Sub SELECT

"Bruno Almeida do Lago" <[EMAIL PROTECTED]> writes: > I'm just getting familiar with EXPLAIN ANALYZE output, so I'd like to get > some help to identify which one of the following queries would be better: Well, you're breaking one of the first laws of PG performance analysis, which is to not try to