| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, mark reid <mail(at)markreid(dot)org>, pgsql-bugs(at)postgresql(dot)org, Jan Wieck <JanWieck(at)Yahoo(dot)com> |
| Subject: | Re: pg_autovacuum: short, wide tables |
| Date: | 2005-07-08 20:02:36 |
| Message-ID: | 27909.1120852956@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew T. O'Connor | 2005-07-08 20:22:22 | Re: pg_autovacuum: short, wide tables |
| Previous Message | Alvaro Herrera | 2005-07-08 19:38:23 | Re: pg_autovacuum: short, wide tables |