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

Re: postgres eating CPU on HP9000

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: "Marcus Andree S(dot) Magalhaes" <marcus(dot)magalhaes(at)vlinfo(dot)com(dot)br>,<scott(dot)marlowe(at)ihs(dot)com>
Cc: <nfesposi(at)sourceweave(dot)net>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: postgres eating CPU on HP9000
Date: 2004-03-28 19:24:43
Message-ID: 200403281124.43275.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Marcus,

> We are experiencing exactly the same problem here, and we use 7.4 on
> Linux/i386 SMP (2 processors). Our databases does even more access:
> about 30k selects per hour, 10k updates and inserts per hour
>
> Vacuum analyze is done daily.

What is your max_fsm_pages setting?     If you are getting 10,000 updates per 
hour, daily VACUUM ANALYZE may not be enough.

Also do you run VACUUM ANALYZE as a superuser, or as a regular user?

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2004-03-28 19:25:41
Subject: Re: column size too large, is this a bug?
Previous:From: Tom LaneDate: 2004-03-28 17:16:18
Subject: Re: severe performance issue with planner

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