From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200408311917.i7VJHHO18285@candle.pha.pa.us>
Subject: Re: FAQ -- Index usage/speed
In-Reply-To: <B46D902C-FB81-11D8-A844-000D93AE0944@sitening.com>
To: "Thomas F.O'Connell" <tfo@sitening.com>
Date: Tue, 31 Aug 2004 15:17:17 -0400 (EDT)
Cc: pgsql-docs@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

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