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

From Jeff Janes
Subject Re: [Proposal] More Vacuum Statistics
Date
Msg-id CAMkU=1ySQOwXEbe4dWjZ1iEEDuotq_GscQngtVFQb0UjMaqTfw@mail.gmail.com
Whole thread Raw
In response to [Proposal] More Vacuum Statistics  (Naoya Anzai <nao-anzai@xc.jp.nec.com>)
List pgsql-hackers
On Thu, May 28, 2015 at 4:08 AM, Naoya Anzai <nao-anzai@xc.jp.nec.com> wrote:

2. Page visibility rate of each table
There is no way to know how many page-bits are them of each tables stored
in their visibility maps. If we can show this information, then we will be
able to guess vacuum overhead for the table. For example, if this table is a
very big table but page visibility rate is high, then we can advise pg-users
that vacuum for this table will execute faster than they think by low I/O overhead.
Furthermore, this information can also be used in order to inform pg-users
about "real" index-only-scan usability.

Isn't this already pg_class.relallvisible?

 
Cheers,

Jeff

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Re: [GENERAL] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1
Next
From: Tom Lane
Date:
Subject: Re: fsync-pgdata-on-recovery tries to write to more files than previously