Re: Reporting xmin from VACUUMs

On 2/15/17 12:05 PM, Alvaro Herrera wrote:
> Jim Nasby wrote:
>> ISTR previous discussion of allowing more stats files; if that happened
>> I think having stats that were dedicated to (auto)vacuum would be very
>> useful. That's clearly a lot more work though.
>
> What?

There's a bunch of information reported by vacuum logging but not in
pg_stat*, such as all-visible/frozen skipping, unable to get cleanup
lock, last freeze scan, times autovac has been interrupted. There's been
resistance in the past to further bloating the existing stats files, but
if we allowed more than one stats file per database that bloat would be
less of a concern (since vacuum stats will see far less update traffic
than the main relation stats).
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)