Lazy vacuum space reclaiming

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: pgsql-docs(at)postgresql(dot)org
Subject: Lazy vacuum space reclaiming
Date: 2005-10-14 18:51:33
Message-ID: 20051014185133.GR23883@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

>From http://www.postgresql.org/docs/8.0/interactive/maintenance.html:

"The first form, known as "lazy vacuum" or just VACUUM, marks expired
data in tables and indexes for future reuse; it does not attempt to
reclaim the space used by this expired data immediately. Therefore, the
table file is not shortened, and any unused space in the file is not
returned to the operating system."

This isn't completely accurate, though I'm not sure what a good wording
would be. Maybe:

"The first form, known as "lazy vacuum" or just VACUUM, marks expired
data in tables and indexes for future reuse. It only reclaims expired
space from tables if it is at the end of the table, and no empty space
is reclaimed from indexes."
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message Volkan YAZICI 2005-10-16 08:15:50 Will PQregisterThreadLock() be documented?
Previous Message Dave Page 2005-10-13 21:31:24 Re: [DOCS] Typo in README.dist-split