Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 50DA19FB3CA for ; Fri, 12 Jan 2007 13:45:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 20603-05 for ; Fri, 12 Jan 2007 13:45:29 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web30014.mail.mud.yahoo.com (web30014.mail.mud.yahoo.com [209.191.69.31]) by postgresql.org (Postfix) with SMTP id 1E6579FB360 for ; Fri, 12 Jan 2007 13:45:30 -0400 (AST) Received: (qmail 28148 invoked by uid 60001); 12 Jan 2007 17:45:29 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=kHUSc6Q0C4iVM2KY9A7gA7BQ5penkjtprpt0+kwEwTb0Iltdkg5cwVbxBpaJg+J3pPrYlDv/eYZS/yO0HCaEwsVIX5lya3bcoqv7CMLLF5j7D/aAD9d3+shtBIiFZjbjojhwYLM6G5H44DjeDzFV0gEj7tSizN7hCtLg9V1mhec=; Received: from [200.161.5.135] by web30014.mail.mud.yahoo.com via HTTP; Fri, 12 Jan 2007 09:45:28 PST X-Mailer: YahooMailRC/368.3 YahooMailWebService/0.6.132.6 Date: Fri, 12 Jan 2007 09:45:28 -0800 (PST) From: Mario Behring Subject: deleting records from a table To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-754859633-1168623928=:26875" Message-ID: <4186.26875.qm@web30014.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/38 X-Sequence-Number: 27190 --0-754859633-1168623928=:26875 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Hi all,=0A=0ASimple question: once I execute the delete statement, does it = free disk space immediatelly? Does Postgres uses something like a datafile = with a pre-defined size like Oracle does??=0A=0APlease advise.=0A=0AThank y= ou.=0A=0AMario=0A=0A=0A=0A=0A =0A__________________________________________= __________________________________________=0AGet your own web address. =0A= Have a HUGE year through Yahoo! Small Business.=0Ahttp://smallbusiness.yaho= o.com/domains/?p=3DBESTDEAL --0-754859633-1168623928=:26875 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Hi all,

Simple question: once I execute the delete statement= , does it free disk space immediatelly? Does Postgres uses something like a= datafile with a pre-defined size like Oracle does??

Please advise.<= br>
Thank you.

Mario

=0A=0A
=0ADon= 't get soaked. Take a quick peak at the forecast
with the= Yahoo! Search weather shortcut. --0-754859633-1168623928=:26875--