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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
