Received: from home.macrotex.com (IDENT:root@www.macrotex.com [208.211.141.227]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA97450 for ; Mon, 16 Aug 1999 20:21:34 -0400 (EDT) (envelope-from stan@cyberfort.com) Received: from cyberfort.com (216-119-140-28.ipset20.wt.net [216.119.140.28]) by home.macrotex.com (8.8.7/8.8.7) with ESMTP id TAA13059 for ; Mon, 16 Aug 1999 19:21:32 -0500 Message-ID: <37B8AA89.9B45BBE0@cyberfort.com> Date: Mon, 16 Aug 1999 19:19:22 -0500 From: Stanley Morgan Organization: CyberFort, Inc. X-Mailer: Mozilla 4.6 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: PGSQL Subject: defragmentation Content-Type: multipart/mixed; boundary="------------6BFCBD80537BA5FDD62F4A44" This is a multi-part message in MIME format. --------------6BFCBD80537BA5FDD62F4A44 Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit Can somebody tell me how can I defragment postgresql's database. For example I have a table with 100000 records in it. Then I execute "Delete from table;", but the file size of this table is still large. 10x --------------6BFCBD80537BA5FDD62F4A44 Content-Type: text/x-vcard; charset=koi8-r; name="stan.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Stanley Morgan Content-Disposition: attachment; filename="stan.vcf" begin:vcard n:Morgan;Stanley tel;home:USA (409) 7667888 x-mozilla-html:TRUE adr:;;;;;; version:2.1 email;internet:stan@cyberfort.com x-mozilla-cpt:;-28368 fn:Stanley Morgan end:vcard --------------6BFCBD80537BA5FDD62F4A44--