Minimum tuple threshold to decide last pass of VACUUM

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>
Subject: Minimum tuple threshold to decide last pass of VACUUM
Date: 2015-08-02 12:13:52
Message-ID: CAB7nPqQTvgMAk3L9o-Rwn9g283fQ9TanKhftrEuDiz14Gexxag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

Commit 4046e58c (dated of 2001) has introduced the following comment
in vacuumlazy.c:
+ /* If any tuples need to be deleted, perform final vacuum cycle */
+ /* XXX put a threshold on min nuber of tuples here? */
+ if (vacrelstats->num_dead_tuples > 0)
In short, we may want to have a reloption to decide if we do or not
the last pass of VACUUM or not depending on a given number of
remaining tuples. Is this still something we would like to have?

Regards,
--
Michael

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2015-08-02 14:15:14 Re: upgrade failure from 9.5 to head
Previous Message Andreas Seltenreich 2015-08-02 09:12:56 [sqlsmith] subplan variable reference / unassigned NestLoopParams (was: [sqlsmith] Failed assertion in joinrels.c)