"Reinoud van Leeuwen" <reinoud(at)xs4all(dot)nl> writes:
> I have a table that contains almost 8 milion rows. The primary key is a
> sequence, so the index should have a good distribution. Why does the
> optimizer refuse to use the index for getting the maximum value?
The optimizer has no idea that max() has anything to do with indexes.
You could try something like
select * from tab order by foo desc limit 1;
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2001-09-26 16:10:00|
|Subject: Spinlock performance improvement proposal|
|Previous:||From: Tom Lane||Date: 2001-09-26 15:15:00|
|Subject: Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES |