TRUNCATE pg_largeobject

From: Tamas Vincze <vincze(at)neb(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: TRUNCATE pg_largeobject
Date: 2011-07-25 17:08:03
Message-ID: 4E2DA2F3.9020007@neb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Best 2011-07-25 17:38:12 9.0 Streaming Replication Problem to two slaves
Previous Message Tom Lane 2011-07-25 16:32:16 Re: streaming replication does not work across datacenter with 20ms latency?