Jack Coates <jack(at)lyris(dot)com> writes:
> That completed in 3.5 minutes on MS-SQL. I killed the query this morning
> after 15 hours on PostgreSQL 7.4. I tried a GROUP BY memberid_ HAVING
> variation, which completed in 59 seconds on MS-SQL. I killed it after 35
> minutes on PostgreSQL.
Hm. I'd like to think that 7.4 would be competitive on grouping
queries. What sort of plan did you get from it?
regards, tom lane
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2004-01-29 18:41:19|
|Subject: Re: On the performance of views|
|Previous:||From: Jack Coates||Date: 2004-01-29 17:23:00|
|Subject: Re: query optimization question|