On 8/19/15 2:56 AM, Masahiko Sawada wrote:
The currently regression test for VM is that we just compare between the total number of all-visible and all-frozen in VM before and after VACUUM, and don't check particular a bit in VM. we could substitute it to the ANALYZE command with enough sampling number and checking pg_class.relallvisible and pg_class.relallfrozen.
I think this is another indication that we need more than just pg_regress...
So another way is that diagnostic function for VM is put into something contrib (pg_freespacemap or pageinspect), and if we want to use such function in production, we can install such extension as in the past.
pg_buffercache is very useful as a performance monitoring tool, and I view being able to pull statistics about the VM and FM the same way. I'd like to see us providing more performance information by default, not less.
I think things like pageinspect are very different; I really can't see any use for those beyond debugging (and debugging by an expert at that).
-- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers