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

Re: Lazy vacuum space reclaiming

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: Lazy vacuum space reclaiming
Date: 2005-12-07 05:36:12
Message-ID: 200512070536.jB75aCm14675@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-docs
Adjustment patch applied.  Thanks.

---------------------------------------------------------------------------

Jim C. Nasby wrote:
> >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
> 
> ---------------------------(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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-docs by date

Next:From: Bruce MomjianDate: 2005-12-08 18:01:54
Subject: Re: pl/pgSQL doco patch
Previous:From: kdioDate: 2005-12-02 13:12:49
Subject: Re: Table A-1. PostgreSQL Error Codes (WITH constants)

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