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

pgsql-server: Recommend ALTER TABLE ...

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql-server: Recommend ALTER TABLE ...
Date: 2004-05-27 03:30:38
Message-ID: 20040527033038.5B168D1CA43@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Recommend ALTER TABLE ... TYPE as the best way to reclaim space occupied by deleted columns.  The old method involving UPDATE and VACUUM FULL will be considerably less efficient.

Modified Files:
--------------
    pgsql-server/doc/src/sgml/ref:
        alter_table.sgml (r1.69 -> r1.70)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql-server/doc/src/sgml/ref/alter_table.sgml.diff?r1=1.69&r2=1.70)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2004-05-27 03:38:04
Subject: pgsql-server: Change pg_ctl to be in C.
Previous:From: Neil ConwayDate: 2004-05-27 01:00:42
Subject: pgsql-server: Add an index entry for "Performance Tips".

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