Re: BUG: PG do not use index

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: Raw Message | Whole Thread | 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.

In response to

Browse pgsql-bugs by date

  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