pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql 7.4.8 : vacuum and blobs ?
2+ messages / 2 participants
[nested] [flat]
* pgsql 7.4.8 : vacuum and blobs ?
@ 2005-05-30 15:25 FM <dist-list@LEXUM.UMontreal.CA>
0 siblings, 1 reply; 2+ messages in thread
From: FM @ 2005-05-30 15:25 UTC (permalink / raw)
To: pgsql-admin
Hello,
I had a large DB (db1) 12 GB using Blobs. To remvoe old large objects I
connected to db1 and did a <vacuum full analyse>. But the database size
is still 12GB.
How can I clan lod blobs from database ?
Thanks
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgsql 7.4.8 : vacuum and blobs ?
@ 2005-05-30 15:40 Tom Lane <tgl@sss.pgh.pa.us>
parent: FM <dist-list@LEXUM.UMontreal.CA>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2005-05-30 15:40 UTC (permalink / raw)
To: FM <dist-list@LEXUM.UMontreal.CA>; +Cc: pgsql-admin
FM <dist-list@LEXUM.UMontreal.CA> writes:
> How can I clan lod blobs from database ?
LOs don't go away just because they aren't referenced anywhere;
an explicit delete has to be issued.
You probably want to use contrib/vacuumlo.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-05-30 15:40 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-30 15:25 pgsql 7.4.8 : vacuum and blobs ? FM <dist-list@LEXUM.UMontreal.CA>
2005-05-30 15:40 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox