Re: Vacuum statistics

------=_Part_8499_11054492.1209737389377
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

What version of Postgres you are running ?

If you are using 8.3, you can use pg_stat_all_tables.If Not you can use
http://www.postgresql.org/docs/current/static/pgstattuple.html

Chirag

On Tue, Apr 29, 2008 at 8:14 AM, Francisco Reyes <lists@[EMAIL PROTECTED]
>
wrote:

> I recall reading posts in the past where one could query the stat tables
> and see how well autovacuum was performing. Not finding the posts.
>
>
> I found this query:
> SELECT relname, relkind, reltuples, relpages FROM pg_class where relkind
=
> 'r';
>
> From the output how can I tell the number of dead tuples? Or how
effective
> autovacuum is in the particular table..
>
> Recently inheritted several large Postgresql DBs (tables in the hundreds
> of millions and some tables over a billion rows) and I am just starting
to
> go over them and see how autovacuum has been performing.
>
>
> --
> Sent via pgsql-performance mailing list
(pgsql-performance@[EMAIL PROTECTED]
)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>

------=_Part_8499_11054492.1209737389377
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

What version of Postgres you are running ?<br><br>If you are using 8.3,
you can use <tt class="STRUCTNAME">pg_stat_all_tables.</tt>If Not you can
use <a
href="http://www.postgresql.org/docs/current/static/pgstattuple.html">http://www.postgresql.org/docs/current/static/pgstattuple.html</a><br>
<br><tt class="STRUCTNAME">Chirag<br></tt><br><div class="gmail_quote">On
Tue, Apr 29, 2008 at 8:14 AM, Francisco Reyes &lt;<a
href="mailto:lists@[EMAIL PROTECTED]
">lists@[EMAIL PROTECTED]
>&gt;
wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid
rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
I recall reading posts in the past where one could query the stat tables
and see how well autovacuum was performing. Not finding the posts.<br>
<br>
<br>
I found this query:<br>
SELECT relname, relkind, reltuples, relpages FROM pg_class where relkind =
&#39;r&#39;;<br>
<br>
From the output how can I tell the number of dead tuples? Or how effective
autovacuum is in the particular table..<br>
<br>
Recently inheritted several large Postgresql DBs (tables in the hundreds
of millions and some tables over a billion rows) and I am just starting to
go over them and see how autovacuum has been performing.<br><font
color="#888888">
<br>
<br>
-- <br>
Sent via pgsql-performance mailing list (<a
href="mailto:pgsql-performance@[EMAIL PROTECTED]
"
target="_blank">pgsql-performance@[EMAIL PROTECTED]
>)<br>
To make changes to your subscription:<br>
<a href="http://www.postgresql.org/mailpref/pgsql-performance"
target="_blank">http://www.postgresql.org/mailpref/pgsql-performance</a><br>
</font></blockquote></div><br>

------=_Part_8499_11054492.1209737389377--