| From: | Kevin Grittner <kgrittn(at)ymail(dot)com> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Optimal checkpoint_setting |
| Date: | 2014-10-09 20:46:26 |
| Message-ID: | 1412887586.79471.YahooMailNeo@web122303.mail.ne1.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
John R Pierce <pierce(at)hogranch(dot)com> wrote:
> 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.
Nor would I do this if pgdata is anywhere near the size of a memory
segment on a NUMA machine. I have seen cache pre-warming through a
single process on NUMA absolutely kill performance.
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2014-10-09 20:47:26 | Re: PostgreSQL server won't start, corrupt? |
| Previous Message | Ray Stell | 2014-10-09 20:45:18 | Re: PostgreSQL server won't start, corrupt? |