Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 13139650E81 for ; Mon, 30 Jun 2008 20:41:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42896-02 for ; Mon, 30 Jun 2008 20:41:35 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.159]) by postgresql.org (Postfix) with ESMTP id 05F0E650E9F for ; Mon, 30 Jun 2008 20:41:39 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so956357fgg.23 for ; Mon, 30 Jun 2008 16:41:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:cc:in-reply-to:mime-version:content-type:references; bh=wgly5meQqJop8HkV7c7E1SR7Tr+gY1l/ITWqBvTr2YM=; b=C897Pd+K7Eb29H6+Gig9pmLZBHStN9wD7vEBjnFTaSnByRoj4SLRaz2lX4JqZ0sWcg +kKDDVX7jdH1XyMi7mGW5gfvgQKGIOEphi/Ivd5WuJqxbqkdQHutlsMzK7lSaGl30nSi xKBJ0xNRaWvS+vM8esQ6J3RVaSUBwsSXo0DAU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version :content-type:references; b=phJAnaUwygCclE4gkmHHKL9tsaDUMSb5yb7USjR2LY0fkw7eH3MHpeLGMXh9RgjIyb iFvisv0qshuH1xaq84W5Opzdm5ZHz50WnOTqjxCobe+OZMJ4RtnvkkAcxx5tWkt6IGRP kYieh+gUKXS9u1lOdL6NEZdmZgJ4qJJSomTnk= Received: by 10.86.59.18 with SMTP id h18mr3406561fga.4.1214869298395; Mon, 30 Jun 2008 16:41:38 -0700 (PDT) Received: by 10.86.71.17 with HTTP; Mon, 30 Jun 2008 16:41:38 -0700 (PDT) Message-ID: <3a0028490806301641y780fdf52o9d6c473a9fe91d88@mail.gmail.com> Date: Mon, 30 Jun 2008 20:41:38 -0300 From: "Rafael Domiciano" To: "Alvaro Herrera" Subject: Re: Configuring Shared Buffers Cc: "Tino Schwarze" , pgsql-admin@postgresql.org In-Reply-To: <20080630231940.GE18252@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8184_15146385.1214869298384" 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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.106 tagged_above=0 required=5 tests=AWL=0.105, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200806/260 X-Sequence-Number: 29598 ------=_Part_8184_15146385.1214869298384 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 : > Rafael Domiciano escribi=F3: > > 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. > ------=_Part_8184_15146385.1214869298384 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline No, i don't have autovacum.
We tried it sometime ago, and the applic= ations began to take "time-out".
I think we don't need aut= ovacum, along the day the application don't get slow, sometimes is fast= er (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=F3:
> 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 res= ponse
> begin to late, and the applications begin to take "Time-out"= .

Have you tuned autovacuum?  Maybe you need it to be more frequen= t on
certain tables or something.

--
Alvaro Herrera                 &nbs= p;              http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

------=_Part_8184_15146385.1214869298384--