On Tue, Oct 25, 2005 at 22:36:58 -0500,
"Jim C. Nasby" <[EMAIL PROTECTED]> wrote:
> We need the output of EXPLAIN ANALYZE, from both versions if possible.
Isn't that going to be a problem in this case since it seems unlikely
that EXPLAIN ANALYZE will finish in a reasonable amount of time?
>
>
We need the output of EXPLAIN ANALYZE, from both versions if possible.
Also, pgsql-performance would be a better list for this...
On Tue, Oct 25, 2005 at 05:31:22PM -0600, Sidar L?pez Cruz wrote:
> what happend with postgresql 8.1b4 performance on query?
>
> look at this:
> select count(*) from
what happend with postgresql 8.1b4 performance on query?
look at this:
select count(*) from fotos where archivo not in (select archivo from
archivos)
Aggregate (cost=4899037992.36..4899037992.37 rows=1 width=0)
-> Seq Scan on fotos (cost=22598.78..4899037338.07 rows=261716 width=0)
F
