Re: how to shrink pg_attribute table in some database

Thanks for quick response, Keith.

Can you explain your point more deeply, why its a bad idea to do
backup/restore of pg_attribute?

2018-03-26 16:41 GMT+03:00 Keith <keith(at)keithf4(dot)com>:

>
>
> 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
>