pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
defragmentation
3+ messages / 2 participants
[nested] [flat]

* defragmentation
@ 1999-08-17 00:19 Stanley Morgan <stan@cyberfort.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Stanley Morgan @ 1999-08-17 00:19 UTC (permalink / raw)
  To: 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

Attachments:

stan.vcf (text/x-vcard, 183B) download begin:vcard n:Morgan;Stanley tel;home:USA (409) 7667888 x-mozilla-html:TRUE adr:;;;;;; version:2.1 email;internet:stan@cyberfort.com x-mozilla-cpt:;-28368 fn:Stanley Morgan end:vcard
^ permalink raw reply [nested|flat] 3+ messages in thread

* RE: [SQL] defragmentation
@ 1999-08-17 00:41 Michael J Davis <michael.j.davis@tvguide.com>
  1999-08-17 02:56 ` Re: [SQL] defragmentation Stanley Morgan <stan@cyberfort.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Michael J Davis @ 1999-08-17 00:41 UTC (permalink / raw)
  To: 'Stanley Morgan' <stan@cyberfort.com>; pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: [SQL] defragmentation
  1999-08-17 00:41 RE: [SQL] defragmentation Michael J Davis <michael.j.davis@tvguide.com>
@ 1999-08-17 02:56 ` Stanley Morgan <stan@cyberfort.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Stanley Morgan @ 1999-08-17 02:56 UTC (permalink / raw)
  To: Michael J Davis <michael.j.davis@tvguide.com>; +Cc: pgsql-sql

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

Attachments:

stan.vcf (text/x-vcard, 183B) download begin:vcard n:Morgan;Stanley tel;home:USA (409) 7667888 x-mozilla-html:TRUE adr:;;;;;; version:2.1 email;internet:stan@cyberfort.com x-mozilla-cpt:;-28368 fn:Stanley Morgan end:vcard
^ permalink raw reply [nested|flat] 3+ messages in thread


end of thread, other threads:[~1999-08-17 02:56 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-08-17 00:19 defragmentation Stanley Morgan <stan@cyberfort.com>
1999-08-17 00:41 RE: [SQL] defragmentation Michael J Davis <michael.j.davis@tvguide.com>
1999-08-17 02:56 ` Stanley Morgan <stan@cyberfort.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox