[GENERAL] TRUNCATE pg_largeobject

2011-07-25 Thread Tamas Vincze
Is it safe? This table is around 500GB and because of performance reasons I slowly moved all large objects to regular files on a NetApp share. Now it shows 0 records: # select count(*) from pg_largeobject; count --- 0 (1 row) but disk space and RAM by the free space map is still occu

Re: [GENERAL] TRUNCATE pg_largeobject

2011-07-25 Thread Tamas Vincze
d I'd like some advice whether to use VACUUM FULL or TRUNCATE. -Tamas Hey Tamas, 2011/7/25 Tamas Vincze mailto:vin...@neb.com>> Is it safe? This table is around 500GB and because of performance reasons I slowly moved all large objects to regular files on a NetApp