Re: free space map

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Chris Hoover <revoohc(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: free space map
Date: 2006-06-20 15:32:57
Message-ID: 2389.1150817577@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Alvaro Herrera <alvherre(at)commandprompt(dot)com> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Sriram Dandapani 2006-06-20 16:13:18 Re: truncate partitioned table locking
Previous Message Sriram Dandapani 2006-06-20 15:30:39 Re: truncate partitioned table locking