RE: [SQL] defragmentation

From: Michael J Davis <michael(dot)j(dot)davis(at)tvguide(dot)com>
To: "'Stanley Morgan'" <stan(at)cyberfort(dot)com>, PGSQL <pgsql-sql(at)postgreSQL(dot)org>
Subject: RE: [SQL] defragmentation
Date: 1999-08-17 00:41:52
Message-ID: 93C04F1F5173D211A27900105AA8FCFC299189@lambic.prevuenet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Vacuum.

-----Original Message-----
From: Stanley Morgan [SMTP:stan(at)cyberfort(dot)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 >>

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stanley Morgan 1999-08-17 02:56:59 Re: [SQL] defragmentation
Previous Message Bruce Momjian 1999-08-17 00:23:53 Re: [SQL] example of a simple function]