pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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:^ permalink raw reply [nested|flat] 3+ messages in threadstan.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
* 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:^ permalink raw reply [nested|flat] 3+ messages in threadstan.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
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