From: Bruno Almeida do Lago <teolupus@gmail.com>
To: 'Tom Lane' <tgl@sss.pgh.pa.us>
Cc: pgsql-performance@postgresql.org
Subject: Re: GROUP BY Vs. Sub SELECT
Date: Mon, 24 Apr 2006 11:36:18 -0300
Message-ID: <444ce266.1ca74910.7370.ffffe386@mx.gmail.com> (raw)
In-Reply-To: <18881.1145835264@sss.pgh.pa.us>
OK! I totally understand what you said. I'll load this table with a
simulated data and see how PG deals with it.
About the queries being different, yes, I'm sure they are :-) I did not
mention that application is able to handle both.
I'd like to get more info on EXPLAIN ANALYZE output... where can I read more
about it?
Thank you very much for your attention!!
Regards,
Bruno
-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Sunday, April 23, 2006 8:34 PM
To: Bruno Almeida do Lago
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] GROUP BY Vs. Sub SELECT
"Bruno Almeida do Lago" <teolupus@gmail.com> 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 extrapolate the behavior on large tables from the
behavior on toy tables. You can't really see where the bottlenecks are
on a toy example, and what's more there's no reason to think that the
planner will use the same plan when presented with much larger tables.
So you need to load up a meaningful amount of data (don't forget to
ANALYZE afterward!) and then see what it does.
> I think 2nd would be better, since when database grow up the GROUP BY may
> become too costly. Is that right?
The two queries don't give the same answer, so asking which is faster
is a bit irrelevant. (When there's more than one group, wouldn't the
per-group MAXes be different?)
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: teolupus@gmail.com, tgl@sss.pgh.pa.us
Subject: Re: GROUP BY Vs. Sub SELECT
In-Reply-To: <444ce266.1ca74910.7370.ffffe386@mx.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox