Postgres Pro
Downloads
Home   >   mailing lists

Can postgres handle "group by" queries? - Mailing list pgsql-general

From Abraham, Danny
Subject Can postgres handle "group by" queries?
Date
Msg-id BE67D1149BBD5746984545ED91F702E0461C76@hou-ex-02.adprod.bmc.com
Whole thread Raw
Responses Re: Can postgres handle "group by" queries?
List pgsql-general
Tree view 
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@bmc.com

pgsql-general by date:

Previous
From: Sebastián Baioni
Date:
Subject: Can't make backup
Next
From: Raymond O'Donnell
Date:
Subject: Re: Can postgres handle "group by" queries?