Skip site navigation (1) Skip section navigation (2)

Re: query optimization question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jack Coates <jack(at)lyris(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: query optimization question
Date: 2004-01-29 18:05:04
Message-ID: 25064.1075399504@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
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

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2004-01-29 18:41:19
Subject: Re: On the performance of views
Previous:From: Jack CoatesDate: 2004-01-29 17:23:00
Subject: Re: query optimization question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group