Re: [SQL] Deleting large objects from database. - Mailing list pgsql-sql

From neko@kredit.sth.szif.hu
Subject Re: [SQL] Deleting large objects from database.
Date
Msg-id Pine.LNX.4.10.9912141908460.9851-100000@kredit.sth.szif.hu
Whole thread Raw
In response to Deleting large objects from database.  (Czarny Marcin <Marcin.Czarny@plock.petrochemia.pl>)
List 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;(



pgsql-sql by date:

Previous
From: "Harald Kirschner"
Date:
Subject: wildcards with datetime columns
Next
From: De Moudt Walter
Date:
Subject: Re: [SQL] SQL'92 web resources