Received: from corppo1.uvsg.com (corppo1.uvsg.com [192.40.65.90]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA01295 for ; Mon, 16 Aug 1999 20:43:18 -0400 (EDT) (envelope-from michael.j.davis@tvguide.com) Received: from prevuepo1.uvsg.com ([192.40.65.44]) by corppo1.uvsg.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id Q2LGVKWP; Mon, 16 Aug 1999 19:44:19 -0500 Received: by prevuepo1.uvsg.com with Internet Mail Service (5.5.2448.0) id ; Mon, 16 Aug 1999 19:47:20 -0500 Message-ID: <93C04F1F5173D211A27900105AA8FCFC299189@lambic.prevuenet.com> From: Michael J Davis To: "'Stanley Morgan'" , PGSQL Subject: RE: [SQL] defragmentation Date: Mon, 16 Aug 1999 19:41:52 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2448.0) Content-Type: text/plain 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 >>