Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Trivial patch to double vacuum speed on tables with no indexes - Mailing list pgsql-patches

From Tom Lane
Subject Re: [HACKERS] Trivial patch to double vacuum speed on tables with no indexes
Date
Msg-id 13384.1157406328@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Trivial patch to double vacuum speed  (Bruce Momjian <bruce@momjian.us>)
Responses Re: [HACKERS] Trivial patch to double vacuum speed
List pgsql-patches
Tree view 
Bruce Momjian <bruce@momjian.us> writes:
> Patch applied.  Thanks.

Wait a minute.   This patch changes the behavior so that
LockBufferForCleanup is applied to *every* heap page, not only the ones
where there are removable tuples.  It's not hard to imagine scenarios
where that results in severe system-wide performance degradation.
Has there been any real-world testing of this idea?

            regards, tom lane

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Trivial patch to double vacuum speed
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Trivial patch to double vacuum speed