Re: how to shrink pg_attribute table in some database

From: Keith <keith(at)keithf4(dot)com>
To: Artem Tomyuk <admin(at)leboutique(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: how to shrink pg_attribute table in some database
Date: 2018-03-26 13:41:12
Message-ID: CAHw75vuFvy_Tn9ZT0zANugeJOLhrfcmxv4r+XeJV0NszVNmn5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Mar 26, 2018 at 9:35 AM, Artem Tomyuk <admin(at)leboutique(dot)com> wrote:

> Hi, Gurus!!!!
>
> Maybe someone knows what is the best way to shrink pg_attribute in size?
> Maybe backup and restore of this table will sanitize "dead" records in it?
> Or only full vacuum can help in this situation?
>
> Thanks!
>

VACUUM FULL would be the way to go if bloat is the issue you're trying to
fix. Trying to backup up & restore a single system catalog would not be
recommended.

Keith

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Artem Tomyuk 2018-03-26 13:43:51 Re: how to shrink pg_attribute table in some database
Previous Message Artem Tomyuk 2018-03-26 13:35:56 how to shrink pg_attribute table in some database