X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 1A1C4D79EB for ; Sat, 26 Nov 2005 06:39:22 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23351-08 for ; Sat, 26 Nov 2005 10:39:23 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.194]) by svr1.postgresql.org (Postfix) with ESMTP id 83C98D730C for ; Sat, 26 Nov 2005 06:39:19 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i28so1464924wra for ; Sat, 26 Nov 2005 02:39:22 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=MjVOGd5ilzMY8cmzKsbEKKdSh/SCj5lPP3MW1zmJuaz4hjti0DaAUOOgFW0qeUObScf2DO8oXepZqeEkUxVm1bAyAhswDDZeNqoAWw+Sk1N5WfncBkkA8oufGkV/q61MJUVAbqW/BTPNr6dpzhTQjSmRx7Ifg7JLFFEVOoxhLSk= Received: by 10.54.66.7 with SMTP id o7mr3739229wra; Sat, 26 Nov 2005 02:39:22 -0800 (PST) Received: by 10.54.117.8 with HTTP; Sat, 26 Nov 2005 02:39:22 -0800 (PST) Message-ID: <9e4684ce0511260239n1dd62c5cq3abdb3eee69705ec@mail.gmail.com> Date: Sat, 26 Nov 2005 11:39:22 +0100 From: hubert depesz lubaczewski To: Colton Smith Subject: Re: pgstattuple, vacuum and free_space Cc: pgsql-admin@postgresql.org In-Reply-To: <43860F20.5080709@skio.peachnet.edu> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_18075_27064431.1133001562135" References: <43860F20.5080709@skio.peachnet.edu> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200511/316 X-Sequence-Number: 19689 ------=_Part_18075_27064431.1133001562135 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 11/24/05, Colton Smith wrote: > > My question: when you vacuum a table and generate 'free_space', who is > allowed to consume this 'free_space'? Is it released to the OS for > general use? Or is it reserved just for the database? If the latter, is > it reserved just for 'wind' (in this case)? > as far as i know this space is mapped as free witinh data-files of table "wind". thus effectivelyu - your OS doesnt get more free space, nor is (generally speaking) the database. benefit of this "free space" is that next inserts to wind table will fit inside of this free space - thus stopping bloat of datafiles of this table. if you would like to reclaim the disk-space, you should consider using vacuum full. depesz ------=_Part_18075_27064431.1133001562135 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline On 11/24/05, Colton Smith <smith@skio.peachnet.edu> wrote:
=
My question: when you vacuum a table and generate 'free_space', who is
a= llowed to consume this 'free_space'? Is it released to the OS for
genera= l use? Or is it reserved just for the database? If the latter, is
it res= erved just for 'wind' (in this case)?


as far as i know this space is mapped as free witinh data-files of table &q= uot;wind".
thus effectivelyu - your OS doesnt get more free space, nor is (generally s= peaking) the database.
benefit of this "free space" is that next inserts to wind table w= ill fit inside of this free space - thus stopping bloat of datafiles of this table.

if you would like to reclaim the disk-space, you should consider using vacu= um full.

depesz
------=_Part_18075_27064431.1133001562135--