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

Re: large objects & space usage

From: David Wall <d(dot)wall(at)computer(dot)org>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: large objects & space usage
Date: 2008-01-14 00:58:28
Message-ID: 478AB3B4.1090600@computer.org (view raw or flat)
Thread:
Lists: pgsql-admin
> 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


In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2008-01-14 02:04:50
Subject: Re: large objects & space usage
Previous:From: Vishal MailinglistDate: 2008-01-13 22:13:40
Subject: Re: Need some info.

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