Re: how to shrink pg_attribute table in some database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx>:


On Mon, Mar 26, 2018 at 9:35 AM, Artem Tomyuk <admin@xxxxxxxxxxxxxx> 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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux