Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id EA375650F25
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 30 Jun 2008 21:13:30 -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 64872-06-2 for
	<pgsql-admin-postgresql.org@postgresql.org>;
	Mon, 30 Jun 2008 21:13: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.153])
	by postgresql.org (Postfix) with ESMTP id D4177650EEA
	for <pgsql-admin@postgresql.org>; Mon, 30 Jun 2008 21:12:49 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 16so961071fgg.23
	for <pgsql-admin@postgresql.org>; Mon, 30 Jun 2008 17:12:47 -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=MkIgdm1ec6wQqubtka52FbTLor9pT5ZaD0T8Wd9/5yE=;
	b=sNzf8fedtyoCf8H89nMMGZg2CcXbG4PxR1g5Cq4ctXJt3hNITgE59JJq+7rouHkHS8
	eaVbsuEcosniQXeUt0vYf1hL/1h2qXpOKRjcDUQRA9jioy04UGaPgkiLTR38Un6oRleX
	LFooLwZtCxgsBNHZ/y+ERchiqWTYFhb3RxljM=
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=JyuK5nFK0piUuZnLXJjdarfBNTtXV0VYxNaZna76qwGtZkxrJErRGSADW4um2FtJvi
	mqIT8HRt/cgpm852iFxWX8VMNgYSssVrfMs8nQxnCQI5GzibiIjtGIqKlFTwZhnHAqu6
	01TDqyFCLVdARtjvMt6GddpjU+Dk6gkPfN3IQ=
Received: by 10.86.57.9 with SMTP id f9mr6893338fga.66.1214871167730;
	Mon, 30 Jun 2008 17:12:47 -0700 (PDT)
Received: by 10.86.71.17 with HTTP; Mon, 30 Jun 2008 17:12:47 -0700 (PDT)
Message-ID: <3a0028490806301712o6a07d77nba5faded7fa4fb98@mail.gmail.com>
Date: Mon, 30 Jun 2008 21:12:47 -0300
From: "Rafael Domiciano" <rafael.domiciano@gmail.com>
To: "Alvaro Herrera" <alvherre@commandprompt.com>
Subject: Re: Configuring Shared Buffers
Cc: "Tino Schwarze" <postgresql@tisc.de>, pgsql-admin@postgresql.org
In-Reply-To: <20080630235959.GG18252@alvh.no-ip.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_8215_658206.1214871167741"
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>
	<3a0028490806301651l6f3f58a3y5297ae59272b82f0@mail.gmail.com>
	<20080630235959.GG18252@alvh.no-ip.org>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.087 tagged_above=0 required=5 tests=AWL=0.086,
	HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200806/266
X-Sequence-Number: 29604

------=_Part_8215_658206.1214871167741
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

No, but is more common Insert and Update than delete.
While I have around 50.000 Insert and Update, in delete is 5.000

2008/6/30 Alvaro Herrera <alvherre@commandprompt.com>:

> Rafael Domiciano escribi=F3:
> > I have schedelus to run vacuum at the night, it starts at 01:00 AM
>
> Do you execute lots of updates or deletes on some tables?
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>

------=_Part_8215_658206.1214871167741
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

No, but is more common Insert and Update than delete.<br>While I have aroun=
d 50.000 Insert and Update, in delete is 5.000<br><br><div class=3D"gmail_q=
uote">2008/6/30 Alvaro Herrera &lt;<a href=3D"mailto:alvherre@commandprompt=
.com">alvherre@commandprompt.com</a>&gt;:<br>
<blockquote class=3D"gmail_quote" style=3D"border-left: 1px solid rgb(204, =
204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Rafael Domiciano =
escribi=F3:<br>
<div class=3D"Ih2E3d">&gt; I have schedelus to run vacuum at the night, it =
starts at 01:00 AM<br>
<br>
</div>Do you execute lots of updates or deletes on some tables?<br>
<div><div></div><div class=3D"Wj3C7c"><br>
--<br>
Alvaro Herrera &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbs=
p; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a href=3D"http://www.Co=
mmandPrompt.com/" target=3D"_blank">http://www.CommandPrompt.com/</a><br>
PostgreSQL Replication, Consulting, Custom Development, 24x7 support<br>
</div></div></blockquote></div><br>

------=_Part_8215_658206.1214871167741--