[GENERAL] Can postgres handle "group by" queries?

From: Abraham, Danny <danny_abraham(at)bmc.com>
Date: Mon Dec 31 2007 - 10:07:55 EST

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

---------------------------(end of broadcast)---------------------------

TIP 5: don't forget to increase your free space map settings Received on Mon Dec 31 10:09:36 2007