From: Tom Lane <tgl@sss.pgh.pa.us>
To: Burgholzer, Robert (DEQ) <Robert.Burgholzer@deq.virginia.gov>
Cc: pgsql-admin@postgresql.org
Subject: Re: proper tuning for restoring from pg_dump in 8.3.7
Date: Wed, 14 Jul 2010 13:19:37 -0400
Message-ID: <8594.1279127977@sss.pgh.pa.us> (raw)
In-Reply-To: <B6C40D17104BEF47B1CB85623CDFAC63895E51@COVMSGCES-EMB13.cov.virginia.gov>
References: <B6C40D17104BEF47B1CB85623CDFAC63895DE6@COVMSGCES-EMB13.cov.virginia.gov>
<1279126650.22775.9.camel@jd-desktop.unknown.charter.com>
<B6C40D17104BEF47B1CB85623CDFAC63895E51@COVMSGCES-EMB13.cov.virginia.gov>
"Burgholzer, Robert (DEQ)" <Robert.Burgholzer@deq.virginia.gov> writes:
> That said, the time to restore is explainable, but is there something in
> my tuning that is causing all of my memory to be eaten?
That's normal behavior. A working Linux/Unix system *should* have near
zero free memory. If it doesn't, either the filesystem cache is failing
to do its job, or you recently booted the machine and it hasn't had a
chance to fill the cache, or you bought way more RAM than your workload
has any use for.
> We seem to have some undiagnosed issue whereby opening and closing large
> files on the system leaves a lot in the cache -- I am guessing that this
> is my culprit and NOT my pg tuning?
That's called "it's working correctly".
If you want to get an accurate picture of whether the system is under
memory pressure, you need to discount filesystem cache, and also pay
attention to whether anything much has been pushed out to swap.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Robert.Burgholzer@deq.virginia.gov
Subject: Re: proper tuning for restoring from pg_dump in 8.3.7
In-Reply-To: <8594.1279127977@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox