Postgres Pro
Downloads
Home   >   mailing lists

Re: Inoptimal query plan for max() and multicolumn index - Mailing list pgsql-performance

From Vladimir Kulev
Subject Re: Inoptimal query plan for max() and multicolumn index
Date
Msg-id BANLkTinWEEyWTO5e0Zq5omAgO=OLZ_FJ7g@mail.gmail.com
Whole thread Raw
In response to Re: Inoptimal query plan for max() and multicolumn index  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: Inoptimal query plan for max() and multicolumn index
List pgsql-performance
Tree view 
Yes, exactly :)

On Mon, Jun 20, 2011 at 7:41 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> 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@lightoze.net

Skype: lightoze

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Contemplating SSD Hardware RAID
Next
From: Yeb Havinga
Date:
Subject: Re: Contemplating SSD Hardware RAID