Re: optimizer question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Reinoud van Leeuwen" <reinoud(at)xs4all(dot)nl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: optimizer question
Date: 2001-09-26 15:19:00
Message-ID: 946.1001517540@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-09-26 16:10:00 Spinlock performance improvement proposal
Previous Message Tom Lane 2001-09-26 15:15:00 Re: PERFORMANCE IMPROVEMENT by mapping WAL FILES