X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id F1EE2D1B241 for ; Fri, 25 Jun 2004 14:35:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23429-06 for ; Fri, 25 Jun 2004 17:35:29 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id C827CD1B1C9 for ; Fri, 25 Jun 2004 14:35:26 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i5PHZQH1018885; Fri, 25 Jun 2004 13:35:26 -0400 (EDT) To: Carlos Benkendorf Cc: pgsql-admin@postgresql.org Subject: Re: Vacuum x Vacuum full In-reply-to: <20040625164231.34710.qmail@web60305.mail.yahoo.com> References: <20040625164231.34710.qmail@web60305.mail.yahoo.com> Comments: In-reply-to Carlos Benkendorf message dated "Fri, 25 Jun 2004 09:42:31 -0700" Date: Fri, 25 Jun 2004 13:35:26 -0400 Message-ID: <18884.1088184926@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/338 X-Sequence-Number: 13998 Carlos Benkendorf writes: > I could not clear my doubt. Will the standard form, free disk space to the > operational system or not? It will release space to the OS if (a) there are one or more completely empty pages at the end of the table and (b) it is able to get an exclusive lock on the table (ie, there's not anyone else using the table at the time). regards, tom lane