From: | Wells Oliver <wells(dot)oliver(at)gmail(dot)com> |
---|---|
To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
Cc: | Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: Determine potential change in table size after a column dropped? |
Date: | 2022-01-24 16:08:10 |
Message-ID: | CAOC+FBWhRvt9TORHxG1K1AA_MCE+0Y=j7wUzuD6wQShEzDCbdA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
So, there's really no way to reclaim space from a dropped column other than
entirely creating a new table?
On Mon, Jan 24, 2022 at 12:28 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:
> On Sat, 2022-01-22 at 09:08 -0800, Wells Oliver wrote:
> > I need only drop the column and VACUUM FULL the table, and not the
> entire DB, right?
>
> Not that VACUUM (FULL) will *not* physically get rid of a dropped column,
> as it just copies the complete rows to a new table.
>
> You would need something like:
>
> CREATE TABLE newtab (LIKE oldtab);
> INSERT INTO newtab SELECT * FROM oldtab;
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2022-01-24 16:30:42 | Re: Determine potential change in table size after a column dropped? |
Previous Message | Thomas Kellerer | 2022-01-24 08:44:12 | Re: Determine potential change in table size after a column dropped? |