defragmentation

From: Stanley Morgan <stan(at)cyberfort(dot)com>
To: PGSQL <pgsql-sql(at)postgresql(dot)org>
Subject: defragmentation
Date: 1999-08-17 00:19:22
Message-ID: 37B8AA89.9B45BBE0@cyberfort.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Attachment Content-Type Size
stan.vcf text/x-vcard 184 bytes

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-08-17 00:23:53 Re: [SQL] example of a simple function]
Previous Message Clayton Cottingham 1999-08-16 23:41:51 Re: [SQL] example of a simple function