pgsql: Reduce the size of memory allocations by lazy vacuum when

From: alvherre(at)postgresql(dot)org (Alvaro Herrera)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Reduce the size of memory allocations by lazy vacuum when
Date: 2007-09-24 03:52:55
Message-ID: 20070924035255.9F991753E4C@cvs.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

Log Message:
-----------
Reduce the size of memory allocations by lazy vacuum when processing a small
table, by allocating just enough for a hardcoded number of dead tuples per
page. The current estimate is 200 dead tuples per page.

Per reports from Jeff Amiel, Erik Jones and Marko Kreen, and subsequent
discussion.
CVS: ----------------------------------------------------------------------
CVS: Enter Log. Lines beginning with `CVS:' are removed automatically
CVS:
CVS: Committing in .
CVS:
CVS: Modified Files:
CVS: commands/vacuumlazy.c
CVS: ----------------------------------------------------------------------

Modified Files:
--------------
pgsql/src/backend/commands:
vacuumlazy.c (r1.99 -> r1.100)
(http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuumlazy.c?r1=1.99&r2=1.100)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2007-09-24 03:53:02 pgsql: Reduce the size of memory allocations by lazy vacuum when
Previous Message Tom Lane 2007-09-24 03:23:51 Re: pgsql: Remove "convert 'blah' using conversion_name" facility, because

Browse pgsql-hackers by date

  From Date Subject
Next Message Jonah H. Harris 2007-09-24 04:10:33 Re: GCC builtins for atomic-test-and-set, memory barries, and such
Previous Message Tom Lane 2007-09-24 03:42:13 Re: GCC builtins for atomic-test-and-set, memory barries, and such