X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 5A78E9FA15C
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 16 May 2006 15:09:30 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 43506-03
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Tue, 16 May 2006 15:09:24 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nz-out-0102.google.com (nz-out-0102.google.com
 [64.233.162.207])
	by postgresql.org (Postfix) with ESMTP id B4CA39F9C9E
	for <pgsql-admin@postgresql.org>; Tue, 16 May 2006 15:09:24 -0300 (ADT)
Received: by nz-out-0102.google.com with SMTP id j2so61007nzf
	for <pgsql-admin@postgresql.org>; Tue, 16 May 2006 11:09:23 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=da+1yfcXTWtIOBqr2oTizoIi5FKg5j3oVAvosvfVNAkHcFvrZLk79kDM1/rM/HRONLVB+Bhndd/OgBnOCtXiE2/UWPpLDF01McufJh8v3SMbYoR2PCau/Am3jvV5Kk4ryUQqXsywyOU1dARackkVK6VO3mUriaeAhxIOqkD5no4=
Received: by 10.36.135.17 with SMTP id i17mr750153nzd;
	Tue, 16 May 2006 11:09:23 -0700 (PDT)
Received: by 10.36.74.15 with HTTP; Tue, 16 May 2006 11:09:23 -0700 (PDT)
Message-ID: <674d1f8a0605161109v1292daf1j509baf29442faadc@mail.gmail.com>
Date: Tue, 16 May 2006 23:39:23 +0530
From: "Gourish Singbal" <gourish@gmail.com>
To: "Chris Hoover" <revoohc@gmail.com>
Subject: Re: More Autovacuum Questions
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <1d219a6f0605161100j1a397288y5ed17493542f6f45@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_14321_5114563.1147802963626"
References: <1d219a6f0605161100j1a397288y5ed17493542f6f45@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200605/224
X-Sequence-Number: 21756

------=_Part_14321_5114563.1147802963626
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

U can install pgstattuple module which is available in the contrib director=
y
and run it on production as

psql> \x
psql> select * from pgstattuple('public'.'tablename');

it displays the table_len, tuple_count, tuple_len, tuple_percent,
dead_tuple_count, dead_tuple_len,dead_tuple_percent,free_space,free_percent
for the table .


On 5/16/06, Chris Hoover <revoohc@gmail.com> wrote:
>
> Thanks to those who answered my first question.  I am looking at
> implementing autovacuuming on our new production 8.1.3 systems.  I am
> reading the documentation on the various configuration parameters.  The
> autovacuum_analyze_threshold and autovacuum_vacuum_threshold talk about t=
he
> number of updated and deleted tuples.  Is there anyway to calculate these
> numbers in a running database?
>
> The reason I'm asking is that we are having some sporadic slowness issues
> with our databases, and I'm wanting to see how the database looks during
> these times.  I know that vacuuming some specific tables tends to fix the
> problem.  So, if I can see what autovacuum might see, I could set the
> parameters correctly to try and fix the issue.
>
> Anyway, are these number available to me?
>
> Thanks,
>
>
> Chris
>



--=20
Best,
Gourish Singbal

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

<div>&nbsp;</div>
<div>U can install pgstattuple module which is available in the contrib dir=
ectory and run it on production as </div>
<div>&nbsp;</div>
<div>psql&gt; \x</div>
<div>psql&gt; select * from pgstattuple('public'.'tablename');<br>&nbsp;</d=
iv>
<div>it displays the table_len, tuple_count, tuple_len, tuple_percent, dead=
_tuple_count, dead_tuple_len,dead_tuple_percent,free_space,free_percent for=
 the table .</div>
<div>&nbsp;</div>
<div>&nbsp;</div>
<div><span class=3D"gmail_quote">On 5/16/06, <b class=3D"gmail_sendername">=
Chris Hoover</b> &lt;<a href=3D"mailto:revoohc@gmail.com">revoohc@gmail.com=
</a>&gt; wrote:</span>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px 0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>Thanks to those who answered my first question.&nbsp; I am looking at =
implementing autovacuuming on our new production 8.1.3 systems.&nbsp; I am =
reading the documentation on the various configuration parameters.&nbsp; Th=
e autovacuum_analyze_threshold and autovacuum_vacuum_threshold talk about t=
he number of updated and deleted tuples.&nbsp; Is there anyway to calculate=
 these numbers in a running database?=20
<br><br>The reason I'm asking is that we are having some sporadic slowness =
issues with our databases, and I'm wanting to see how the database looks du=
ring these times.&nbsp; I know that vacuuming some specific tables tends to=
 fix the problem.&nbsp; So, if I can see what autovacuum might see, I could=
 set the parameters correctly to try and fix the issue.=20
<br><br>Anyway, are these number available to me?<br><br>Thanks,<br>&nbsp;<=
/div>
<div><span class=3D"sg"><br>Chris<br></span></div></blockquote></div><br><b=
r clear=3D"all"><br>-- <br>Best,<br>Gourish Singbal=20

------=_Part_14321_5114563.1147802963626--