Re: pgsql 7.4.8 : vacuum and blobs ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: FM <dist-list@xxxxxxxxxxxxxxxxxx>
Subject: Re: pgsql 7.4.8 : vacuum and blobs ?
From: Tom Lane <tgl@xxxxxxxxxxxxx>
Date: Mon, 30 May 2005 11:40:59 -0400
Cc: Mailing List Postgres-Admin <pgsql-admin@xxxxxxxxxxxxxx>
Comments: In-reply-to FM <dist-list@xxxxxxxxxxxxxxxxxx> message dated "Mon, 30 May 2005 11:25:09 -0400"
In-reply-to: <429B3055.4040406@xxxxxxxxxxxxxxxxxx>
References: <429B3055.4040406@xxxxxxxxxxxxxxxxxx>

FM <dist-list@xxxxxxxxxxxxxxxxxx> 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

References:
- pgsql 7.4.8 : vacuum and blobs ?
  - From: FM

Prev by Date: pgsql 7.4.8 : vacuum and blobs ?
Next by Date: Starting postgres server second time using admin rights...
Previous by thread: pgsql 7.4.8 : vacuum and blobs ?
Next by thread: Starting postgres server second time using admin rights...
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux