> 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@gmail.com> 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@postgresql.org)
> 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.