Postgres Pro
Downloads
Home   >   mailing lists

Skipping VACUUM of indexes when no work required - Mailing list pgsql-patches

From Simon Riggs
Subject Skipping VACUUM of indexes when no work required
Date
Msg-id 1133956836.2906.891.camel@localhost.localdomain
Whole thread Raw
Responses Re: Skipping VACUUM of indexes when no work required  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Skipping VACUUM of indexes when no work required  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Tree view 
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

pgsql-patches by date:

Previous
From: "Los Mejores Cursos Gubernamentales"
Date:
Subject: Capacitacion para Servidores Publicos ciclo Dic-Enero //*0512759742388adr
Next
From: Simon Riggs
Date:
Subject: Minor spelling correction on cvstip