Skip site navigation (1) Skip section navigation (2)

more blob questions

From: Kevin Kempter <kevin(at)kevinkempterllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: more blob questions
Date: 2008-01-18 04:45:25
Message-ID: 200801172145.25911.kevin@kevinkempterllc.com (view raw or flat)
Thread:
Lists: pgsql-admin
Hi List;

Suppose I have a table with say an integer key, a char column and a large 
object column.

can I simply delete a row from the table (delete from bigtable where...), then 
run a vacuum (or vacuum full) ? If so, in this scenario will postgres release 
the space back to the OS or must I first remove the large object with 
lo_unlink() ?

also, does the contrib vacuumlo perform tasks I cannot do via vacuum and  
lo_unlink ?

Thanks in advance..

/Kevin

Responses

pgsql-admin by date

Next:From: Suresh Gupta VGDate: 2008-01-18 13:15:17
Subject: Cannot bind socket
Previous:From: Mischa SandbergDate: 2008-01-17 23:52:33
Subject: Re: [ADMIN] postgresql in FreeBSD jails: proposal

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group