From: Richard Huxton <dev@archonet.com>
To: Mike <akiany@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Vacuum and Memory Loss
Date: Mon, 23 Oct 2006 09:45:59 +0100
Message-ID: <453C8147.60609@archonet.com> (raw)
In-Reply-To: <1161307454.955144.107400@m73g2000cwd.googlegroups.com>
References: <1161307454.955144.107400@m73g2000cwd.googlegroups.com>
Mike wrote:
> Hello friends,
>
> I am responsible for maintaining a high volume website using postgresql
> 8.1.4. Given the amount of reads and writes, I vacuum full the server a
> few times a week around 1, 2 AM shutting down the site for a few
> minutes. The next day morning around 10 - 11 AM the server slows down
> to death. It used to be that the error 'Too many clients' would be
> recorded, until I increased the number of clients it can handle, and
> now it simply slows down to death having lots and lots of postmaster
> processes running:
>
> Tasks: 665 total, 10 running, 655 sleeping, 0 stopped, 0 zombie
> Cpu(s): 14.9% us, 16.7% sy, 0.0% ni, 0.0% id, 68.4% wa, 0.0% hi,
> 0.0% si
> Mem: 2074932k total, 2051572k used, 23360k free, 2736k
> buffers
> Swap: 2096440k total, 1844448k used, 251992k free, 102968k cached
This seems to be saying you have 1.8GB of swap in use. I'd start by
checking with vmstat whether you're actively swapping. If so, you're
overallocating memory.
--
Richard Huxton
Archonet Ltd
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-performance@postgresql.org
Cc: dev@archonet.com, akiany@gmail.com
Subject: Re: Vacuum and Memory Loss
In-Reply-To: <453C8147.60609@archonet.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