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