"andremachado" <andremachado(at)techforce(dot)com(dot)br> writes:
> Firebird has something similiar to EXPLAIN. Please look below.
Hm, maybe I just don't know how to read their output, but it's not
obvious to me where they are doing the min/max aggregates.
> Is there something really wrong with the postgresql configuration (at my
> previous msg) that is causing this poor performance at these 2 queries?
I don't think it's a configuration issue, it's a quality-of-plan issue.
Could you put together a self-contained test case for this problem? I
don't have the time or interest to try to reverse-engineer tables and
test data for these queries --- but I would be interested in finding out
where the time is going, if I could run the queries.
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Jim C. Nasby||Date: 2006-04-27 17:50:16|
|Subject: Re: Running on an NFS Mounted Directory|
|Previous:||From: Vivek Khera||Date: 2006-04-27 15:19:36|
|Subject: Re: Large (8M) cache vs. dual-core CPUs|