Postgres Pro
Downloads
Home   >   mailing lists

defragmentation - Mailing list pgsql-sql

From Stanley Morgan
Subject defragmentation
Date
Msg-id 37B8AA89.9B45BBE0@cyberfort.com
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "tjk@tksoft.com"
Date:
Subject: Re: [SQL] datediff function
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] example of a simple function]