Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 04B8A633A5B
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  9 Jun 2009 14:51:28 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 49292-04 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  9 Jun 2009 14:51:27 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from out01.mta.xmission.com (out01.mta.xmission.com [166.70.13.231])
	by mail.postgresql.org (Postfix) with ESMTP id 0B039632449
	for <pgsql-sql@postgresql.org>; Tue,  9 Jun 2009 14:51:27 -0300 (ADT)
Received: from in01.mta.xmission.com ([166.70.13.51])
	by out01.mta.xmission.com with esmtp (Exim 4.62)
	(envelope-from <robjsargent@gmail.com>)
	id 1ME5U6-00081a-0T; Tue, 09 Jun 2009 11:51:42 -0600
Received: from [208.187.158.94] (helo=[172.16.1.231])
	by in01.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1ME5Tp-0007nL-HJ; Tue, 09 Jun 2009 11:51:25 -0600
Message-ID: <4A2EA121.2070004@gmail.com>
Date: Tue, 09 Jun 2009 11:51:29 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Thunderbird 2.0.0.21 (X11/20090318)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-XM-SPF: eid=; ; ; mid=; ; ; hst=in01.mta.xmission.com; ; ;
 ip=208.187.158.94;
	; ; frm=robjsargent@gmail.com; ; ; spf=neutral
X-SA-Exim-Connect-IP: 208.187.158.94
X-SA-Exim-Rcpt-To: pgsql-sql@postgresql.org, robjsargent@gmail.com
X-SA-Exim-Mail-From: robjsargent@gmail.com
X-Spam-DCC: XMission; sa01 1397; Body=1 Fuz1=1 Fuz2=1 
X-Spam-Combo: ;pgsql-sql@postgresql.org
X-Spam-Relay-Country: 
Subject: Taking the cache out of the equation?
X-SA-Exim-Version: 4.2.1 (built Thu, 25 Oct 2007 00:26:12 +0000)
X-SA-Exim-Scanned: Yes (on in01.mta.xmission.com)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200906/40
X-Sequence-Number: 32645

Caching helps a *lot* and I'm thankful for that but I would like to take 
it out of the picture as I massage my queries for better performance.  
Naturally the first invocation of the query cannot take advantage of the 
cache and these queries would normally only be called once for the same 
target data.    What tricks are there to flush, ignore, circumvent the 
caching boost?  (Especially in the production environment.)