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

From Josh Berkus
Subject Re: postgres eating CPU on HP9000
Date
Msg-id 200403281124.43275.josh@agliodbs.com
Whole thread Raw
In response to Re: postgres eating CPU on HP9000  ("Marcus Andree S. Magalhaes" <marcus.magalhaes@vlinfo.com.br>)
Responses Re: postgres eating CPU on HP9000
List 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

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: severe performance issue with planner
Next
From: Josh Berkus
Date:
Subject: Re: column size too large, is this a bug?