Re: Joint index including MAX() ?

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: Richard Neill <rn214(at)cam(dot)ac(dot)uk>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Joint index including MAX() ?
Date: 2010-01-09 12:51:41
Message-ID: 2f4958ff1001090451j69934f2awce0a4c1fc7a27364@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

you can also try :

select val FROM table ORDER BY val DESC LIMIT 1;

which usually is much quicker.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Lefteris 2010-01-09 12:52:31 Re: Joint index including MAX() ?
Previous Message Kenneth Marshall 2010-01-09 12:46:46 Re: PG optimization question