Skipping VACUUM of indexes when no work required

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: pgsql-patches(at)postgresql(dot)org
Subject: Skipping VACUUM of indexes when no work required
Date: 2005-12-07 12:00:36
Message-ID: 1133956836.2906.891.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

We discussed an optimization of VACUUM here
http://archives.postgresql.org/pgsql-hackers/2005-09/msg00046.php
that would allow VACUUM to complete faster by avoiding scanning the
indexes when no rows were removed from the heap by the VACUUM.

Patch applies cleanly on cvstip; make check passes.

Tests shows clear performance gain when no rows removed by VACUUM.

Not as useful as may once have been, but certainly no loss either,
whatever happens in the future with VACUUM.

Best Regards, Simon Riggs

Attachment Content-Type Size
vacfastpath.patch text/x-patch 10.0 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Simon Riggs 2005-12-07 12:10:38 Minor spelling correction on cvstip
Previous Message miki 2005-12-07 10:30:26 少し変えてみません?