Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 31 Dec 2007 09:07:55 -0600
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
- Follow-Ups:
- Re: Can postgres handle "group by" queries?
- From: Raymond O'Donnell
- Re: Can postgres handle "group by" queries?
- Prev by Date: Can't make backup
- Next by Date: Re: Can postgres handle "group by" queries?
- Previous by thread: Cluster table
- Next by thread: Re: Can postgres handle "group by" queries?
- Indexes: