From: Josh Berkus <josh@agliodbs.com>
To: Fabio Esposito <nfesposi@sourceweave.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgres eating CPU on HP9000
Date: Mon, 29 Mar 2004 11:14:47 -0800
Message-ID: <200403291114.47932.josh@agliodbs.com> (raw)
In-Reply-To: <Pine.LNX.4.44.0403290807560.25270-100000@cr818510-a.basement>
References: <Pine.LNX.4.44.0403290807560.25270-100000@cr818510-a.basement>
Fabio,
> We run VACUUM ANALYZE after we remove about 1000 rows every hour on the
> halh hour. Our max_fsm_pages is set to 10000
Have you checked how long these vacuums take? If they are starting to
overlap, that would explain your high CPU usage and poor performance. You
might want to consider raising FSM_pages and vacuuming less frequently.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
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: josh@agliodbs.com, nfesposi@sourceweave.net
Subject: Re: postgres eating CPU on HP9000
In-Reply-To: <200403291114.47932.josh@agliodbs.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