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

From: Raymond O'Donnell <rod(at)iol.ie>
Date: Mon Dec 31 2007 - 10:09:59 EST

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

---

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

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