Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group