Postgres Pro
Downloads
Home   >   mailing lists

Re: postgres eating CPU on HP9000 - Mailing list pgsql-performance

From Josh Berkus
Subject Re: postgres eating CPU on HP9000
Date
Msg-id 200403291114.47932.josh@agliodbs.com
Whole thread Raw
In response to Re: postgres eating CPU on HP9000  (Fabio Esposito <nfesposi@sourceweave.net>)
Responses Re: postgres eating CPU on HP9000  (Fabio Esposito <nfesposi@sourceweave.net>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: column size too large, is this a bug?
Next
From: Fabio Esposito
Date:
Subject: Re: postgres eating CPU on HP9000