On 1/12/16 6:42 AM, Andres Freund wrote:
Somehow computing the speed in relation to the cluster/database size is
probably possible, but I wonder how we can do so without constantly
re-computing something relatively expensive?


ISTM relpages would probably be good enough for this, if we take the extra step of getting actual relation size when relpages is 0.

I'm not sure a straght scale factor is the way to go though... it seems that might be problematic? I think we'd at least one a minimum default value; you certainly don't want even a small system running vacuum at 1kB/s...
--
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


--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to