Skip site navigation (1) Skip section navigation (2)

Re: FAQ -- Index usage/speed

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Thomas F(dot)O'Connell" <tfo(at)sitening(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: FAQ -- Index usage/speed
Date: 2004-08-31 19:17:17
Message-ID: 200408311917.i7VJHHO18285@candle.pha.pa.us (view raw or flat)
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-docs by date

Next:From: Josh BerkusDate: 2004-09-01 03:11:28
Subject: Re: FAQ -- Index usage/speed
Previous:From: Thomas F.O'ConnellDate: 2004-08-31 19:12:30
Subject: Re: FAQ -- Index usage/speed

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group