Re: seq scan in the case of max() on the primary key column

From: Shaun Thomas <sthomas(at)peak6(dot)com>
To: Jim Nasby <jim(at)nasby(dot)net>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, Svetlin Manavski <svetlin(dot)manavski(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: seq scan in the case of max() on the primary key column
Date: 2011-06-21 19:49:46
Message-ID: 4E00F5DA.8090500@peak6.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 06/17/2011 03:31 PM, Jim Nasby wrote:

> c_parent_oid CONSTANT oid := (p_parent_schema || '.' ||
> p_parent_table )::regclass;

Well isn't *that* a handy bit of magic. How did I not know about that?
Thanks!

--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 800 | Chicago IL, 60604
312-676-8870
sthomas(at)peak6(dot)com

______________________________________________

See http://www.peak6.com/email_disclaimer.php
for terms and conditions related to this email

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Yeb Havinga 2011-06-21 20:10:35 Re: Contemplating SSD Hardware RAID
Previous Message Anton Rommerskirchen 2011-06-21 18:29:26 Re: Contemplating SSD Hardware RAID