View Single Post

   
  #4 (permalink)  
Old 04-10-2008, 08:18 AM
David Wall
 
Posts: n/a
Default Re: large objects & space usage


> If there are no other tables storing large objects in the database,
> dropping and reloading the whole database is probably the simplest
> solution. Otherwise they're going to need to make sure the unwanted
> LOs have been cleaned out (see contrib/vacuumlo) and then do a VACUUM
> FULL or similar on pg_largeobject.
>

Does the psql command 'vacuum;' by itself automatically vacuum
pg_largeobject along with all of tables in the database?

David


---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply With Quote