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

Re: BUG: PG do not use index

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Eugen(dot)Konkov(at)aldec(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG: PG do not use index
Date: 2008-03-25 11:55:00
Message-ID: 20080325115500.GA6756@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Sergey BurladyanDate: 2008-03-25 11:57:55
Subject: Re: can't delete record from second table in rules of view with join select
Previous:From: Sergey BurladyanDate: 2008-03-25 11:13:07
Subject: can't delete record from second table in rules of view with join select

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