|
Home > Archive > PostgreSQL Documentation > December 2005 > Lazy vacuum space reclaiming
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Lazy vacuum space reclaiming
|
|
| Jim C. Nasby 2005-10-27, 8:06 am |
| From http://www.postgresql.org/docs/8.0/...intenance.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@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Bruce Momjian 2005-12-07, 3:40 am |
|
Adjustment patch applied. Thanks.
---------------------------------------------------------------------------
Jim C. Nasby wrote:
>
> "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@pervasive.com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
|
|
|
|
|