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
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 |