From: Joshua D. Drake <jd@commandprompt.com>
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 10:17:36 -0700
Message-ID: <1279127856.22775.21.camel@jd-desktop.unknown.charter.com> (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>
On Wed, 2010-07-14 at 13:07 -0400, Burgholzer, Robert (DEQ) wrote:
> 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?
Please don't top post.
>
> 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?
>
> Thanks again,
> r.b.
You mention the use of top. Assessing just the the reference to "free"
memory isn't as accurate as you would think. I am going to assume you
are using Linux. Linux will suck all (well not all but close) out of
free and put it into things like buffers until free memory is actually
needed.
For example on my workstation:
Mem: 6126116k total, 5910328k used, 215788k free, 495684k buffers
Swap: 3919352k total, 5792k used, 3913560k free, 3178548k cached
Which means exactly nothing, unless that SWAP number starts churning.
Sincerely,
Joshua D. Drake
--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
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: jd@commandprompt.com, Robert.Burgholzer@deq.virginia.gov
Subject: Re: proper tuning for restoring from pg_dump in 8.3.7
In-Reply-To: <1279127856.22775.21.camel@jd-desktop.unknown.charter.com>
* 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