pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Alvaro Herrera <alvherre@commandprompt.com>
To: Rafael Domiciano <rafael.domiciano@gmail.com>
Cc: Tino Schwarze <postgresql@tisc.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Configuring Shared Buffers
Date: Mon, 30 Jun 2008 19:19:41 -0400
Message-ID: <20080630231940.GE18252@alvh.no-ip.org> (raw)
In-Reply-To: <3a0028490806301616v6882a40bi2b54dcf63b37e315@mail.gmail.com>
References: <3a0028490806301052y193a4aeayfcc6deafdeb1cdb2@mail.gmail.com>
	<20080630182830.GA5358@easy2.in-chemnitz.de>
	<3a0028490806301201m5e4c48d4qc51a880b8f80ecf5@mail.gmail.com>
	<20080630191710.GC5358@easy2.in-chemnitz.de>
	<3a0028490806301616v6882a40bi2b54dcf63b37e315@mail.gmail.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.

view thread (17+ messages)  latest in thread

Message-ID: <20080630231940.GE18252@alvh.no-ip.org>
Permalink:  ../20080630231940.GE18252@alvh.no-ip.org/
Also on:    postgresql.org/message-id/20080630231940.GE18252@alvh.no-ip.org

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: alvherre@commandprompt.com, rafael.domiciano@gmail.com, postgresql@tisc.de
  Subject: Re: Configuring Shared Buffers
  In-Reply-To: <20080630231940.GE18252@alvh.no-ip.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox