> 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

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to