Re: Optimal checkpoint_setting - Mailing list pgsql-general

From John R Pierce
Subject Re: Optimal checkpoint_setting
Date
Msg-id 5436F2AC.5030009@hogranch.com
Whole thread Raw
In response to Re: Optimal checkpoint_setting  (Dennis <dennisr@visi.com>)
Responses Re: Optimal checkpoint_setting  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-general
On 10/9/2014 1:13 PM, Dennis wrote:
> Hi, a little off the general topic but I am just wondering if the “tar
> -cf - pgdata | wc -c” trick can be used as general trick to pre-warm
> the cache?

I wouldn't do this if your pgdata is larger than about 50% of your
physical ram.



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Rob Flemming
Date:
Subject: PostgreSQL server won't start, corrupt?
Next
From: Raymond O'Donnell
Date:
Subject: Re: PostgreSQL server won't start, corrupt?