Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Can postgres handle "group by" queries?
- From: Raymond O'Donnell <rod(at)iol(dot)ie>
- To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Can postgres handle "group by" queries?
- Date: Mon, 31 Dec 2007 15:09:59 +0000
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(at)iol(dot)ie ---------------------------------------------------------------
- References:
- Can postgres handle "group by" queries?
- From: Abraham, Danny
- Can postgres handle "group by" queries?
- Prev by Date: Can postgres handle "group by" queries?
- Next by Date: Re: [TLM] Re: batch insert/update
- Previous by thread: Can postgres handle "group by" queries?
- Next by thread: basic questions: Postgres with yum on CentOS 5.1
- Indexes: