X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 083399FA634 for ; Tue, 20 Jun 2006 12:33:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 51926-09 for ; Tue, 20 Jun 2006 12:33:08 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 5A6CA9FA5F0 for ; Tue, 20 Jun 2006 12:33:06 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id k5KFWwi0002390; Tue, 20 Jun 2006 11:33:00 -0400 (EDT) To: Alvaro Herrera cc: Chris Hoover , "pgsql-admin@postgresql.org" Subject: Re: free space map In-reply-to: <20060620150946.GN26882@surnet.cl> References: <1d219a6f0606200744y40714eb5sec53ed5aba3693cc@mail.gmail.com> <20060620150946.GN26882@surnet.cl> Comments: In-reply-to Alvaro Herrera message dated "Tue, 20 Jun 2006 11:09:46 -0400" Date: Tue, 20 Jun 2006 11:32:57 -0400 Message-ID: <2389.1150817577@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/161 X-Sequence-Number: 22123 Alvaro Herrera writes: > In CVS HEAD there is a pg_freespacemap contrib module that may do what > you need. You'd have to "backport" it to 8.1 though; it doesn't compile > as-is. Looking at the CVS history, I think the main point is that freespace.c did not formerly expose its internal data structures; the patch moved a lot of declarations into freespace.h so that the contrib code could get at them. You'd need to modify the 8.1 sources, but not by much. regards, tom lane