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: 200403291114.47932.josh@agliodbs.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group