Re: Inoptimal query plan for max() and multicolumn index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Yes, exactly :)

On Mon, Jun 20, 2011 at 7:41 PM, Kevin Grittner
<Kevin.Grittner@xxxxxxxxxxxx> wrote:
> I expect you're hoping for a plan similar to what this gives you?:
>
> explain analyze select greatest(
>  (select max(timestamp) from sms where number = '5502712'),
>  (select max(timestamp) from sms where number = '5802693'),
>  (select max(timestamp) from sms where number = '5801981'));

-- 
Vladimir Kulev
Mobile: +7 (921) 555-44-22

Jabber: me@xxxxxxxxxxxx

Skype: lightoze

-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux