Thread: Can postgres handle "group by" queries?
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
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@iol.ie ---------------------------------------------------------------