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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Richard Huxton" <dev@xxxxxxxxxxxx>
Subject: Re: simple case using index on windows but not on linux
From: "simon godden" <sgodden@xxxxxxxxx>
Date: Wed, 4 Oct 2006 15:48:52 +0100
Cc: "Postgresql Performance" <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <168519350610040746q64804cbcr6d73e1dd4e8592d7@xxxxxxxxxxxxxx>
References: <168519350610040048m7c4031e3t1a24b3fd4d9265a3@xxxxxxxxxxxxxx> <168519350610040219n648a282hf159ff272e0f672a@xxxxxxxxxxxxxx> <45238085.3000407@xxxxxxxxxxxx> <168519350610040240k346bd99fj9537822d79443f8c@xxxxxxxxxxxxxx> <45238F54.70609@xxxxxxxxxxxx> <168519350610040635r4d041bd7vba47ca0e31a4c7d0@xxxxxxxxxxxxxx> <4523BB75.9020200@xxxxxxxxxxxx> <168519350610040647v395f1aeag8e9c6825ad25320e@xxxxxxxxxxxxxx> <4523C007.4050606@xxxxxxxxxxxx> <168519350610040746q64804cbcr6d73e1dd4e8592d7@xxxxxxxxxxxxxx>

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

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
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]