Re: pg_autovacuum: short, wide tables - Mailing list pgsql-bugs

From Tom Lane
Subject Re: pg_autovacuum: short, wide tables
Date
Msg-id 27909.1120852956@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_autovacuum: short, wide tables  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: pg_autovacuum: short, wide tables
List pgsql-bugs
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Another issue altogether is the stat system.  I don't know if it stores
> info about toast tables.

Yes, it does --- you can pull out the info, even, if you use the stats
access functions directly.  It's just that the views filter on relkind =
'r'.

> Note that it doesn't matter that it doesn't show up in the pg_stat
> views, because we don't use those; rather we access the hash tables
> directly.

Ah, but this is only true in the integrated version no?  The contrib
version sure looks like it's depending on the views.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: pg_autovacuum: short, wide tables
Next
From: "Matthew T. O'Connor"
Date:
Subject: Re: pg_autovacuum: short, wide tables