TRUNCATE pg_largeobject - Mailing list pgsql-general

From Tamas Vincze
Subject TRUNCATE pg_largeobject
Date
Msg-id 4E2DA2F3.9020007@neb.com
Whole thread Raw
Responses Re: TRUNCATE pg_largeobject  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-general
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 occupied.
I'd like to clean it up.
A VACUUM FULL would probably do it, but it would take several
hours with heavy I/O and I'd like to avoid that on a production
server.

Can I safely issue a "TRUNCATE pg_largeobject"?
It is v8.1.9.

Thanks!

pgsql-general by date:

Previous
From: Yan Chunlu
Date:
Subject: Re: streaming replication does not work across datacenter with 20ms latency?
Next
From: Michael Best
Date:
Subject: 9.0 Streaming Replication Problem to two slaves