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

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
(view: Whole thread, Raw)
In response to: Re: Help in avoiding a query 'Warm-Up' period/shared buffer cache  (Mark Liberman)
Responses: Re: Help in avoiding a query 'Warm-Up' period/shared buffer  ("Jim C. Nasby")
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:

From: Tom Lane
Date:
Subject: Re: Slow query. Any way to speed up?
From: "Andy"
Date:
Subject: Re: Improving Inner Join Performance