From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ian Knopke <knopke@music.mcgill.ca>
Cc: pgsql-performance@postgresql.org
Subject: Re: problems
Date: Sun, 20 Apr 2003 14:36:10 -0400
Message-ID: <10082.1050863770@sss.pgh.pa.us> (raw)
In-Reply-To: <Pine.LNX.4.50.0304201404480.21922-100000@www.music.mcgill.ca>
References: <Pine.LNX.4.50.0304201404480.21922-100000@www.music.mcgill.ca>
Ian Knopke <knopke@music.mcgill.ca> writes:
> Comparing the beginning and end times from the log, it seems to take the
> same amount of time to insert at the beginning of the process as after
> about twenty minutes. However, I also logged the input from vmstat, which
> shows the amount of memory available shrinking rapidly.
AFAICT you are just showing us kernel disk cache expanding to fill
unused memory. This is normal and not a cause for alarm.
> Eventually the system moves to using swap and things really slow down.
Disk cache can't cause swapping --- the kernel will just throw away
cached pages when the memory is needed for something else. It could
be that you have growth in the number of Postgres processes, or the
sizes of individual processes, but vmstat isn't very helpful for
determining that (good ol' top would be more useful). In any case
you haven't actually shown us any data from the state where the system
is slow, so it's a bit hard to conjecture about what's going on.
Some other important information that you haven't let us in on is the
platform and the Postgres version you're using.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, knopke@music.mcgill.ca
Subject: Re: problems
In-Reply-To: <10082.1050863770@sss.pgh.pa.us>
References: <Pine.LNX.4.50.0304201404480.21922-100000@www.music.mcgill.ca> <10082.1050863770@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