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 Mamin||Date: 2008-01-14 08:39:16|
|Subject: Re: SQL question: Highest column value of unique column pairs|
|Previous:||From: David Wall||Date: 2008-01-14 00:58:28|
|Subject: Re: large objects & space usage|