From: Rafael Domiciano <rafael.domiciano@gmail.com>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Tino Schwarze <postgresql@tisc.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: Configuring Shared Buffers
Date: Mon, 30 Jun 2008 20:41:38 -0300
Message-ID: <3a0028490806301641y780fdf52o9d6c473a9fe91d88@mail.gmail.com> (raw)
In-Reply-To: <20080630231940.GE18252@alvh.no-ip.org>
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>
<20080630231940.GE18252@alvh.no-ip.org>
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.
>
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: rafael.domiciano@gmail.com, alvherre@commandprompt.com, postgresql@tisc.de
Subject: Re: Configuring Shared Buffers
In-Reply-To: <3a0028490806301641y780fdf52o9d6c473a9fe91d88@mail.gmail.com>
* 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