| From: | <Eugen(dot)Konkov(at)aldec(dot)com> |
|---|---|
| To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
| Cc: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG: PG do not use index |
| Date: | 2008-03-26 08:14:49 |
| Message-ID: | 01cc01c88f19$781b5270$1200a8c0@kharkov.localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
C:\Program Files\PostgreSQL\8.0\bin>postgres --version
postgres (PostgreSQL) 8.0.3
----- Original Message -----
From: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
To: <Eugen(dot)Konkov(at)aldec(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Sent: Tuesday, March 25, 2008 1:55 PM
Subject: Re: [BUGS] BUG: PG do not use index
> Eugen(dot)Konkov(at)aldec(dot)com wrote:
>> Why PG do not use index?
>> select max(id) from akh_testing_result
>
> What PG version are you using? Recent versions should indeed use the
> index. Perhaps you just need to upgrade.
>
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Eugen.Konkov | 2008-03-26 08:20:05 | Re: BUG: PG do not use index |
| Previous Message | Alvaro Herrera | 2008-03-26 01:24:06 | Re: BUG #4059: Vacuum full not always cleaning empty tables |