| From: | ZongtianHou <zongtianhou(at)icloud(dot)com> |
|---|---|
| To: | depesz(at)depesz(dot)com |
| Cc: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: how to clean dropped column in pg_attribute |
| Date: | 2020-09-08 09:51:52 |
| Message-ID: | F972AB05-CB42-4C1A-91E4-F05271A4926C@icloud.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Ok, thanks for this info
Best regards,
Zongtian
> On Sep 8, 2020, at 5:49 PM, hubert depesz lubaczewski <depesz(at)depesz(dot)com> wrote:
>
> On Tue, Sep 08, 2020 at 05:38:24PM +0800, ZongtianHou wrote:
>> I found dropped columns still exist in pg_attribute table. In the
>> below example I drop c2 column and vacuum (full) this table and
>> pg_attribute, it still exist (the last row). how can I clean it away?
>
> Unfortunately only by copying the table aside, and then renaming new
> table.
>
> But - the dropped attribute will not sure any disk space, as long as you
> ran some vacuums.
>
> Best regards,
>
> depesz
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Juan José Santamaría Flecha | 2020-09-08 10:46:50 | Re: Regarding the Spikes in the connection pool on our Database in the particular time period. |
| Previous Message | hubert depesz lubaczewski | 2020-09-08 09:49:17 | Re: how to clean dropped column in pg_attribute |