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

Re: large objects & space usage

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: d(dot)wall(at)computer(dot)org
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: large objects & space usage
Date: 2008-01-14 02:04:50
Message-ID: 17198.1200276290@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
David Wall <d(dot)wall(at)computer(dot)org> writes:
> Does the psql command 'vacuum;' by itself automatically vacuum 
> pg_largeobject along with all of tables in the database? 

Yes, if it's issued by a superuser or the database owner.

However, that won't help much if pg_largeobject has become bloated by a
lot of no-longer-wanted BLOBs.  After deleting those, you'll probably
need VACUUM FULL or CLUSTER or some such if you want to reclaim the
disk space.  Plain VACUUM usually isn't very successful at shortening
a table file.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Marc MaminDate: 2008-01-14 08:39:16
Subject: Re: SQL question: Highest column value of unique column pairs
Previous:From: David WallDate: 2008-01-14 00:58:28
Subject: Re: large objects & space usage

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