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

pgsql: Support rewritten-based full vacuum as VACUUM FULL.

From: itagaki(at)postgresql(dot)org (Takahiro Itagaki)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Support rewritten-based full vacuum as VACUUM FULL.
Date: 2010-01-06 05:31:14
Message-ID: 20100106053114.4EA48753FB7@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Support rewritten-based full vacuum as VACUUM FULL. Traditional
VACUUM FULL was renamed to VACUUM FULL INPLACE. Also added a new
option -i, --inplace for vacuumdb to perform FULL INPLACE vacuuming.

Since the new VACUUM FULL uses CLUSTER infrastructure, we cannot
use it for system tables. VACUUM FULL for system tables always
fall back into VACUUM FULL INPLACE silently.

Itagaki Takahiro, reviewed by Jeff Davis and Simon Riggs.

Modified Files:
--------------
    pgsql/doc/src/sgml/ref:
        vacuum.sgml (r1.56 -> r1.57)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/vacuum.sgml?r1=1.56&r2=1.57)
        vacuumdb.sgml (r1.46 -> r1.47)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/vacuumdb.sgml?r1=1.46&r2=1.47)
    pgsql/src/backend/commands:
        cluster.c (r1.190 -> r1.191)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/cluster.c?r1=1.190&r2=1.191)
        vacuum.c (r1.402 -> r1.403)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuum.c?r1=1.402&r2=1.403)
    pgsql/src/backend/parser:
        gram.y (r2.702 -> r2.703)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.702&r2=2.703)
    pgsql/src/bin/scripts:
        vacuumdb.c (r1.29 -> r1.30)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/scripts/vacuumdb.c?r1=1.29&r2=1.30)
    pgsql/src/include/commands:
        cluster.h (r1.37 -> r1.38)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/commands/cluster.h?r1=1.37&r2=1.38)
    pgsql/src/include/nodes:
        parsenodes.h (r1.422 -> r1.423)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h?r1=1.422&r2=1.423)
    pgsql/src/include/parser:
        kwlist.h (r1.9 -> r1.10)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/parser/kwlist.h?r1=1.9&r2=1.10)
    pgsql/src/test/regress/expected:
        vacuum.out (r1.2 -> r1.3)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/vacuum.out?r1=1.2&r2=1.3)
    pgsql/src/test/regress/sql:
        vacuum.sql (r1.2 -> r1.3)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/vacuum.sql?r1=1.2&r2=1.3)

pgsql-committers by date

Next:From: Michael MeskesDate: 2010-01-06 09:44:05
Subject: pgsql: Applied Zoltan's patch to remove hardware dependant offset
Previous:From: User BmomjianDate: 2010-01-06 05:19:29
Subject: pg-migrator - pg_migrator: Support new backend API to preserve

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