On Wed, Jul 22, 2015 at 8:19 PM, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote: > > Not sure what Jim meant. Maybe he meant to be aware of when spilling to > disk happens? Obviously, things become slower, so maybe you need to > consider it for progress reporting purposes. >
Perhaps the m_w_m determines how many dead tuples lazy_scan_heap() can keep track of before doing a lazy_vacuum_indexes() + lazy_vacuum_heap() round. Smaller the m_w_m, more the number of index scans, slower the progress? Thanks, Amit -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
