Can postgres handle "group by" queries?

From: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Can postgres handle "group by" queries?
Date: 2007-12-31 15:07:55
Message-ID: BE67D1149BBD5746984545ED91F702E0461C76@hou-ex-02.adprod.bmc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

The following query

SELECT START_DATE_IDX, COUNT(*)
FROM RUNINFO_HISTORY
WHERE START_DATE_IDX>=1005
group by START_DATE_IDX

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.

Any idea?

Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
danny_abraham(at)bmc(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2007-12-31 15:09:59 Re: Can postgres handle "group by" queries?
Previous Message vincent.moreau 2007-12-31 14:45:57 Mandatory AS keyword in SELECT statements