Thread: RE: [SQL] defragmentation

Vacuum.
-----Original Message-----From:    Stanley Morgan [SMTP:stan@cyberfort.com]Sent:    Monday, August 16, 1999 6:19 PMTo:
 PGSQLSubject:    [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
tableis still
 
large.
10x << File: Card for Stanley Morgan >> 

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 >>