Re: [SQL] Deleting large objects from database.

From: neko(at)kredit(dot)sth(dot)szif(dot)hu
To: Czarny Marcin <Marcin(dot)Czarny(at)plock(dot)petrochemia(dot)pl>
Cc: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] Deleting large objects from database.
Date: 1999-12-14 18:16:12
Message-ID: Pine.LNX.4.10.9912141908460.9851-100000@kredit.sth.szif.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, 14 Dec 1999, Czarny Marcin wrote:

> I have column with large objects in table named my_table.
> After SQL command:
> delete from my_table;
> they are still files xinv* and xinx* in directory ./data/base/my_db.
The delete records are there still too. To remove them, U may use vacuum;
I'm not sure yet, about the vacuum remove the large objects.
I have seen somewhere an util called 'lovacuum'...

--
nek;(

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message De Moudt Walter 1999-12-14 20:21:26 Re: [SQL] SQL'92 web resources
Previous Message Harald Kirschner 1999-12-14 15:40:42 wildcards with datetime columns