Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 458B7650E8C for ; Mon, 30 Jun 2008 20:51:12 -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 51112-03 for ; Mon, 30 Jun 2008 20:51:04 -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.156]) by postgresql.org (Postfix) with ESMTP id 9AF7D650DBC for ; Mon, 30 Jun 2008 20:51:07 -0300 (ADT) Received: by fg-out-1718.google.com with SMTP id 16so957771fgg.23 for ; Mon, 30 Jun 2008 16:51:05 -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=OI3HanYC+SH6w4QCkUZijbp3wCWJccVc10OYlRCPsEM=; b=u2nQICkmFoZk/5AsG3AEMrAUPIn/rYOjrGHevaN+I5YXq8ICPc+1y03OTBRQK75pAr 5zM+3mIsjIWBah6ERvO1wHxxHS3crO1bI/N8tzPCEC3QcrOY7GFssIsoG3Zs4//eiGbN yiiVw2DI6MIHCJTjlxNeBL38sDoX7uWuHLcgc= 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=EvoJhN8uEzHdFRLPvJCRsjaWH4ulWqIsY+slB1MCKgqXaGC1mpq7yMQaLgS8UT8v5J 7hc7mwKJ0nCM0y3YHTAUrduDPa3x4ulxy9+Fk+tQq0i1Hgr7ExpUbgOkjMh0GOuIkDHF xyanfwOQyP4uXEzD0XserpLDE+76e5jpxvTEI= Received: by 10.86.73.7 with SMTP id v7mr6901831fga.37.1214869865603; Mon, 30 Jun 2008 16:51:05 -0700 (PDT) Received: by 10.86.71.17 with HTTP; Mon, 30 Jun 2008 16:51:05 -0700 (PDT) Message-ID: <3a0028490806301651l6f3f58a3y5297ae59272b82f0@mail.gmail.com> Date: Mon, 30 Jun 2008 20:51:05 -0300 From: "Rafael Domiciano" To: "Alvaro Herrera" Subject: Re: Configuring Shared Buffers Cc: "Tino Schwarze" , pgsql-admin@postgresql.org In-Reply-To: <20080630234536.GF18252@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_8198_19342430.1214869865601" 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> <3a0028490806301641y780fdf52o9d6c473a9fe91d88@mail.gmail.com> <20080630234536.GF18252@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.096 tagged_above=0 required=5 tests=AWL=0.095, HTML_MESSAGE=0.001 X-Spam-Level: X-Archive-Number: 200806/264 X-Sequence-Number: 29602 ------=_Part_8198_19342430.1214869865601 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I have schedelus to run vacuum at the night, it starts at 01:00 AM 2008/6/30 Alvaro Herrera : > Rafael Domiciano escribi=F3: > > 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 ge= t > > 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. > > So how are you vacuuming your tables? > > -- > Alvaro Herrera > http://www.CommandPrompt.com/ > PostgreSQL Replication, Consulting, Custom Development, 24x7 support > ------=_Part_8198_19342430.1214869865601 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline I have schedelus to run vacuum at the night, it starts at 01:00 AM

<= div class=3D"gmail_quote">2008/6/30 Alvaro Herrera <alvherre@commandprompt.com>:
Rafael Domiciano escribi=F3:
> No, i don't have autovacum.
> We tried it sometime ago, and the applications began to take "tim= e-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.

So how are you vacuuming your tables?

--
Alvaro Herrera           &nb= sp;                    http://www.Comman= dPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support<= br>
------=_Part_8198_19342430.1214869865601--