Re: Help in avoiding a query 'Warm-Up' period/shared buffer

From: David Lang <dlang(at)invendra(dot)net>
To: Mark Liberman <mliberman(at)mixedsignals(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Help in avoiding a query 'Warm-Up' period/shared buffer
Date: 2006-01-06 02:50:22
Message-ID: Pine.LNX.4.62.0601051848510.11046@qnivq.ynat.uz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, 5 Jan 2006, Mark Liberman wrote:

> Obviously, I will be testing this - but it might take a few days, as I haven't
> figure out how to simulate the "period of inactivity" to get the data flushed
> out of the cache ... so I have to run this each morning.

cat large_file >/dev/null

will probably do a pretty good job of this (especially if large_file is
noticably larger then the amount of ram you have)

David Lang

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Qingqing Zhou 2006-01-06 03:08:05 Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache
Previous Message Mark Liberman 2006-01-06 02:15:36 Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache