Re: FAQ -- Index usage/speed - Mailing list pgsql-docs

From Bruce Momjian
Subject Re: FAQ -- Index usage/speed
Date
Msg-id 200408311917.i7VJHHO18285@candle.pha.pa.us
Whole thread Raw
In response to Re: FAQ -- Index usage/speed  (Thomas F.O'Connell <tfo@sitening.com>)
List pgsql-docs
Thomas F.O'Connell wrote:
> I thought about that, and it seems like the upgrade path from 7.x ->
> 8.x is going to be slower than among any of the 7.x releases. 8.0 is
> still several months away and it will probably be several months more
> before people who are affected by this issue in production databases.
>
> The other thing I thought about was a caveat in the 7.x documentation
> under indexes, as it doesn't seem to be mentioned anywhere. That would
> keep it off the general FAQ but let folks using 7.x releases know about
> it.

It is on the TODO:

    * -Allow SELECT * FROM tab WHERE int2col = 4 to use int2col index, int8,
      float4, numeric/decimal too

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-docs by date:

Previous
From: Thomas F.O'Connell
Date:
Subject: Re: FAQ -- Index usage/speed
Next
From: Josh Berkus
Date:
Subject: Re: FAQ -- Index usage/speed