Taking the cache out of the equation?

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Taking the cache out of the equation?
Date: 2009-06-09 17:51:29
Message-ID: 4A2EA121.2070004@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.)

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jyoti Seth 2009-06-10 05:08:30 Re: backup
Previous Message Jasen Betts 2009-06-09 12:33:12 Re: backup