Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Reduce the size of memory allocations by lazy vacuum when - Mailing list pgsql-committers

From alvherre@postgresql.org (Alvaro Herrera)
Subject pgsql: Reduce the size of memory allocations by lazy vacuum when
Date
Msg-id 20070924035302.4BC3B753E4C@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
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: ----------------------------------------------------------------------

Tags:
----
REL8_2_STABLE

Modified Files:
--------------
    pgsql/src/backend/commands:
        vacuumlazy.c (r1.81.2.3 -> r1.81.2.4)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuumlazy.c?r1=1.81.2.3&r2=1.81.2.4)

pgsql-committers by date:

Previous
From: alvherre@postgresql.org (Alvaro Herrera)
Date:
Subject: pgsql: Reduce the size of memory allocations by lazy vacuum when
Next
From: alvherre@postgresql.org (Alvaro Herrera)
Date:
Subject: pgsql: Reduce the size of memory allocations by lazy vacuum when