Skip site navigation (1) Skip section navigation (2)

Re: Configuring Shared Buffers

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Rafael Domiciano <rafael(dot)domiciano(at)gmail(dot)com>
Cc: Tino Schwarze <postgresql(at)tisc(dot)de>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Configuring Shared Buffers
Date: 2008-06-30 23:19:41
Message-ID: 20080630231940.GE18252@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
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.

In response to

Responses

pgsql-admin by date

Next:From: Rafael DomicianoDate: 2008-06-30 23:41:38
Subject: Re: Configuring Shared Buffers
Previous:From: Rafael DomicianoDate: 2008-06-30 23:16:02
Subject: Re: Configuring Shared Buffers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group