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

Re: Vacuum analyze in 7.1.1

From: "David Wall" <dwall(at)Yozons(dot)com>
To: <pgsql-general(at)postgresql(dot)org>, <pgsql-interfaces(at)postgresql(dot)org>
Subject: Re: Vacuum analyze in 7.1.1
Date: 2001-06-14 04:15:28
Message-ID: 019d01c0f488$a520e560$5a2b7ad8@expertrade.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
> I'll have to see if JDBC does an unlink anywhere.

Whoa!  Looks like JDBC (as makes sense if you think about the libraries)
doesn't unlink those large objects.  There is a call in the
postgresql-specific for doing the lo_unlink, but it requires an OID, and
when deleting a row, most of the time I only know the primary key, not the
OIDs inside.  So, I guess I'll have to run vacuumlo from contrib before I do
the regular vacuum.

Does anybody know if vacuumlo is truly safe to use?  I just ran it on my
test system and it removed a bunch of orphans, but I just hope they were
really orphans!

David



In response to

pgsql-interfaces by date

Next:From: David WallDate: 2001-06-14 04:16:24
Subject: Re: Vacuum analyze in 7.1.1
Previous:From: David WallDate: 2001-06-14 04:01:08
Subject: Re: Vacuum analyze in 7.1.1

pgsql-general by date

Next:From: David WallDate: 2001-06-14 04:16:24
Subject: Re: Vacuum analyze in 7.1.1
Previous:From: David WallDate: 2001-06-14 04:01:08
Subject: Re: Vacuum analyze in 7.1.1

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