> alter a table column to its own type, like this: > alter table foo alter column my_counter type integer; -- my_counter > is already an integer Is that really reclaim disk space and how ?? For example; if 'my_counter' column is already integer, why do I alter this column to integer again ? Vick Khera wrote: > > On Wed, May 26, 2010 at 10:16 AM, paladine <yasinmalli@xxxxxxxxx> wrote: >> Anyone know another method ? >> > > options to reclaim disk space: > > vacuum full > dump/restore (sometimes faster than vacuum full) > cluster (not mvcc safe as far as i know) > alter a table column to its own type, like this: > alter table foo alter column my_counter type integer; -- my_counter > is already an integer > > sometimes all you need to do is reindex the table (or just the larger > indexes on the table selectively) > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > > -- View this message in context: http://old.nabble.com/reducing-postgresql-disk-space-tp28681415p28690159.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
