Re: [PERFORM] How to clean/truncate / VACUUM FULL pg_largeobject without (much) downtime?

2015-05-22 Thread Jim Nasby
On 5/11/15 4:55 AM, Muthusamy, Sivaraman wrote: Hi Group, Facing a problem where pg_catalog.pg_largetobject has been growing fast recently, in last two weeks. The actual data itself, in user tables, is about 60GB, but pg_catalog.pg_largeobject table is 200GB plues. Please let me know how to

[PERFORM] How to clean/truncate / VACUUM FULL pg_largeobject without (much) downtime?

2015-05-12 Thread Muthusamy, Sivaraman
Hi Group, Facing a problem where pg_catalog.pg_largetobject has been growing fast recently, in last two weeks. The actual data itself, in user tables, is about 60GB, but pg_catalog.pg_largeobject table is 200GB plues. Please let me know how to clean/truncate this table without losing any user