Re: postgres eating CPU on HP9000

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Fabio Esposito <nfesposi(at)sourceweave(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: postgres eating CPU on HP9000
Date: 2004-03-29 19:14:47
Message-ID: 200403291114.47932.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Fabio Esposito 2004-03-29 19:36:24 Re: postgres eating CPU on HP9000
Previous Message Josh Berkus 2004-03-29 19:12:52 Re: column size too large, is this a bug?