pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pgsql 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