Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5KH4ga02989 for ; Wed, 20 Jun 2001 13:04:42 -0400 (EDT) (envelope-from pgsql-general-owner@postgresql.org) Received: from mail1.expertrade.com (r87-43-dsl.sea.lightrealm.net [216.122.43.87]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5E4FKE43938; Thu, 14 Jun 2001 00:15:21 -0400 (EDT) (envelope-from dwall@Yozons.com) Received: from reggae (reggae.expertrade.com [216.122.43.90]) by mail1.expertrade.com (8.9.3/8.9.3) with SMTP id VAA12758; Wed, 13 Jun 2001 21:15:20 -0700 Message-ID: <019d01c0f488$a520e560$5a2b7ad8@expertrade.com> Reply-To: "David Wall" From: "David Wall" To: , References: <00c401c0f43b$a5423000$5a2b7ad8@expertrade.com> <3101.992468005@sss.pgh.pa.us> <006501c0f45b$eca1c580$5a2b7ad8@expertrade.com> <15660.992481431@sss.pgh.pa.us> <016901c0f486$a6372240$5a2b7ad8@expertrade.com> Subject: Re: Vacuum analyze in 7.1.1 Date: Wed, 13 Jun 2001 21:15:28 -0700 Organization: Yozons, Inc. MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200106/742 X-Sequence-Number: 11246 > 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