Skip site navigation (1) Skip section navigation (2)

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:53:12
Message-ID: 20070924035312.8FF80753E4C@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
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_0_STABLE

Modified Files:
--------------
    pgsql/src/backend/commands:
        vacuumlazy.c (r1.50.4.5 -> r1.50.4.6)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuumlazy.c?r1=1.50.4.5&r2=1.50.4.6)

pgsql-committers by date

Next:From: Andrew DunstanDate: 2007-09-24 03:59:51
Subject: Re: pgsql: Remove "convert 'blah' using conversion_name" facility, because
Previous:From: Alvaro HerreraDate: 2007-09-24 03:53:06
Subject: pgsql: Reduce the size of memory allocations by lazy vacuum when

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group