Postgres Pro
Downloads
Home   >   mailing lists

Re: simple case using index on windows but not on linux - Mailing list pgsql-performance

From simon godden
Subject Re: simple case using index on windows but not on linux
Date
Msg-id 168519350610040748q6948ef9es7bd8b6d0c50e623c@mail.gmail.com
Whole thread Raw
In response to Re: simple case using index on windows but not on linux  ("simon godden" <sgodden@gmail.com>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: "simon godden"
Date:
Subject: Re: simple case using index on windows but not on linux
Next
From: Bruno Wolff III
Date:
Subject: Re: Unsubscribe