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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-docs by date

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