> 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?
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Josh Berkus||Date: 2004-03-28 19:25:41|
|Subject: Re: column size too large, is this a bug?|
|Previous:||From: Tom Lane||Date: 2004-03-28 17:16:18|
|Subject: Re: severe performance issue with planner |