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
---------------------------------------------------------------