| From: | Stanley Morgan <stan(at)cyberfort(dot)com> |
|---|---|
| To: | Michael J Davis <michael(dot)j(dot)davis(at)tvguide(dot)com> |
| Cc: | PGSQL <pgsql-sql(at)postgreSQL(dot)org> |
| Subject: | Re: [SQL] defragmentation |
| Date: | 1999-08-17 02:56:59 |
| Message-ID: | 37B8B35B.91A32CBC@cyberfort.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
10x for the replay
Michael J Davis wrote:
> 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 >>
| Attachment | Content-Type | Size |
|---|---|---|
| stan.vcf | text/x-vcard | 184 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stanley Morgan | 1999-08-17 02:58:02 | (no subject) |
| Previous Message | Michael J Davis | 1999-08-17 00:41:52 | RE: [SQL] defragmentation |