Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 4 Oct 2006 15:48:52 +0100
- Message-id: <168519350610040748q6948ef9es7bd8b6d0c50e623c(at)mail(dot)gmail(dot)com>
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
- References:
- simple case using index on windows but not on linux
- From: simon godden
- Re: simple case using index on windows but not on linux
- From: simon godden
- Re: simple case using index on windows but not on linux
- From: Richard Huxton
- Re: simple case using index on windows but not on linux
- From: simon godden
- Re: simple case using index on windows but not on linux
- From: Richard Huxton
- Re: simple case using index on windows but not on linux
- From: Richard Huxton
- Re: simple case using index on windows but not on linux
- From: simon godden
- Re: simple case using index on windows but not on linux
- From: Richard Huxton
- Re: simple case using index on windows but not on linux
- From: simon godden
- simple case using index on windows but not on linux
- Prev by Date: Re: simple case using index on windows but not on linux
- Next by Date: Re: Unsubscribe
- Previous by thread: Re: simple case using index on windows but not on linux
- Next by thread: Re: simple case using index on windows but not on linux
- Indexes: