Re: Can postgres handle "group by" queries?

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can postgres handle "group by" queries?
Date: 2007-12-31 15:09:59
Message-ID: 47790647.90104@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 31/12/2007 15:07, Abraham, Danny wrote:

> runs for about 200s on Postgres, but 13s on MS SQL Server, on the same
> machine.
> The searched column is indexed.
> By reading the "explain" you can tell that the index is being used.

Have you been running VACUUM on the table?

Ray.

---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod(at)iol(dot)ie
---------------------------------------------------------------

In response to

Browse pgsql-general by date

  From Date Subject
Next Message blackwater dev 2007-12-31 15:34:05 Re: [TLM] Re: batch insert/update
Previous Message Abraham, Danny 2007-12-31 15:07:55 Can postgres handle "group by" queries?