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

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 (view raw or flat)
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

pgsql-bugs by date

Next:From: Eugen.KonkovDate: 2008-03-26 08:20:05
Subject: Re: BUG: PG do not use index
Previous:From: Alvaro HerreraDate: 2008-03-26 01:24:06
Subject: Re: BUG #4059: Vacuum full not always cleaning empty tables

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