Re: [Proposal] More Vacuum Statistics - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [Proposal] More Vacuum Statistics
Date
Msg-id 20150530024125.GG6535@alap3.anarazel.de
Whole thread Raw
In response to Re: [Proposal] More Vacuum Statistics  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
Responses Re: [Proposal] More Vacuum Statistics  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Re: [Proposal] More Vacuum Statistics  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [Proposal] More Vacuum Statistics  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
List pgsql-hackers
On 2015-05-29 21:30:57 -0500, Jim Nasby wrote:
> It occurs to me that there's no good reason for vacuum-derived stats to be
> in the stats file; it's not like users run vacuum anywhere near as often as
> other commands. It's stats could be kept in pg_class; we're already keeping
> things like relallvisible there.

While it might be viable to store them somewhere but the stat files, I
don't think pg_class is a good place. Its size is not any less critical
than the stats files. I.e. reading it sits in several rather hot paths,
and we keep tuples from it in memory in a lot of places.

Greetings,

Andres



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: [Proposal] More Vacuum Statistics
Next
From: Peter Eisentraut
Date:
Subject: cannot set view triggers to replica