No, i don't have autovacum.
We tried it sometime ago, and the applications began to take "time-out".
I think we don't need autovacum, along the day the application don't get slow, sometimes is faster (maybe the use of the applications is less).
The actual machine is Dual Core Xeon 1.5 and 2 Gb RAM.
2008/6/30 Alvaro Herrera <
alvherre@commandprompt.com>:
Rafael Domiciano escribió:
> Yes, the server just does S, U, I and D.
> The queries is pretty simples, don't have huge joins across tables...
> In this server I have around 500 tables, the largest are:
> 9 millions tuples | 5 millions tuples
>
> This server is our "authenticator"; the response is need to be "imediatly".
> Today, the monitoring of the server is done using the unix command:
> loguptime
> With the time we discovered that when loguptime is up than 1.0 the response
> begin to late, and the applications begin to take "Time-out".
Have you tuned autovacuum? Maybe you need it to be more frequent on
certain tables or something.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.