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 UAA03860 for ; Mon, 16 Aug 1999 20:59:13 -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 TAA13167; Mon, 16 Aug 1999 19:59:11 -0500 Message-ID: <37B8B35B.91A32CBC@cyberfort.com> Date: Mon, 16 Aug 1999 21:56:59 -0500 From: Stanley Morgan Organization: CyberFort, Inc. X-Mailer: Mozilla 4.6 [en] (Win98; I) X-Accept-Language: en MIME-Version: 1.0 To: Michael J Davis CC: PGSQL Subject: Re: [SQL] defragmentation References: <93C04F1F5173D211A27900105AA8FCFC299189@lambic.prevuenet.com> Content-Type: multipart/mixed; boundary="------------0F0A85EF1C44B2B49530B680" This is a multi-part message in MIME format. --------------0F0A85EF1C44B2B49530B680 Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit 10x for the replay Michael J Davis wrote: > Vacuum. > > -----Original Message----- > From: Stanley Morgan [SMTP:stan@cyberfort.com] > Sent: Monday, August 16, 1999 6:19 PM > To: PGSQL > Subject: [SQL] defragmentation > > 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 << File: Card for Stanley Morgan >> --------------0F0A85EF1C44B2B49530B680 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 --------------0F0A85EF1C44B2B49530B680--