Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance

> 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


pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group