Re: Help in avoiding a query 'Warm-Up' period/shared buffer - Mailing list pgsql-performance

From David Lang
Subject Re: Help in avoiding a query 'Warm-Up' period/shared buffer
Date
Msg-id Pine.LNX.4.62.0601051848510.11046@qnivq.ynat.uz
Whole thread Raw
In response to Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache  (Mark Liberman <mliberman@mixedsignals.com>)
Responses Re: Help in avoiding a query 'Warm-Up' period/shared buffer  ("Jim C. Nasby" <jnasby@pervasive.com>)
List 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

pgsql-performance by date:

Previous
From: Mark Liberman
Date:
Subject: Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache