Re: Bloated pg_catalog.pg_largeobjects

2024-07-22 Thread khan Affan
Hi I would suggest to backup your DB before doing such a thing. Run Vaccum Full, (VACUUM FULL pg_catalog.pg_largeobject) Running this on the system table might be risky Make sure you backup the database. & if you are using PG version above 9.1 use Pg_repack to reclaim the space. Note: It can b

Re: Regarding publish_via_partiton_root with pglogical

2024-07-22 Thread khan Affan
Hi Durgamahesh In pglogical extension, there is no direct equivalent to the publish_via_partition_root option found in the built-in logical replication you can achieve similar results when a new partition is added; you must add it to the replication set using pglogical.replication_set_add_table.