Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 760989FB367 for ; Fri, 12 Jan 2007 13:53:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 61006-08 for ; Fri, 12 Jan 2007 13:53:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web31803.mail.mud.yahoo.com (web31803.mail.mud.yahoo.com [68.142.207.66]) by postgresql.org (Postfix) with SMTP id F32149FB313 for ; Fri, 12 Jan 2007 13:53:34 -0400 (AST) Received: (qmail 1826 invoked by uid 60001); 12 Jan 2007 17:53:33 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=1/3sh/gkHE2m1T0sR6/CJntwTfqgl7HkjSxkDFJhz3eSqgogkbVQHL/AgSgvCrk9O7UlOp/oIJZpTbqK+PlMfSwn0xSU/TNPD8jSnWoNtosUFopGu1zkyTrDage00Vy/g+p8dlYgHzVjavdVxsm10k7RMiTrLcVGQHr5xhdwkEM=; X-YMail-OSG: AFU49fQVM1ni9ifjBQZr5pcPOsoVZx9TOtPfr4Yid7jjWs74JXan9qjsloW.cDthBbWWu.PdaA6tjBIHwmRexeELrExSwwr8x_URAihdD23C5yE.c9.kDEDPwJmD68NeSWQ3RJblsbdT4rmr6s.MnPartryHv4ax Received: from [63.203.180.122] by web31803.mail.mud.yahoo.com via HTTP; Fri, 12 Jan 2007 09:53:33 PST Date: Fri, 12 Jan 2007 09:53:33 -0800 (PST) From: Richard Broersma Jr Subject: Re: deleting records from a table To: Mario Behring , pgsql-sql@postgresql.org In-Reply-To: <4186.26875.qm@web30014.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <877653.1327.qm@web31803.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.659 tagged_above=0 required=5 tests=AWL, BAYES_20, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200701/39 X-Sequence-Number: 27191 ---> Simple question: once I execute the delete statement, does it free disk space immediatelly? No. deleted rows (in a sense) are simply marked as deleted and are made avaliable for being written over by a new or updated tuple. If you want to recover the space you can you TRUNCATE or VACUUM FULL & possible REINDEX. Regards, Richard Broersma Jr.