Re: simple case using index on windows but not on linux

From: "simon godden" <sgodden(at)gmail(dot)com>
To: "Richard Huxton" <dev(at)archonet(dot)com>
Cc: "Postgresql Performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: simple case using index on windows but not on linux
Date: 2006-10-04 14:48:52
Message-ID: 168519350610040748q6948ef9es7bd8b6d0c50e623c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I think I am being stupid now.

The > query was returning so many rows (87% of the rows in the table)
that a seq-scan was of course the best way.

Sorry - all is now working and the problem was the locale issue.

Thanks so much for your help everyone.

--
Simon Godden

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joshua D. Drake 2006-10-04 15:30:03 Re: Unsubscribe
Previous Message simon godden 2006-10-04 14:46:12 Re: simple case using index on windows but not on linux