Re: visibility maps and heap_prune

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Pavan Deolasee <pavan(dot)deolasee(at)gmail(dot)com>
Cc: "pgsql-hackers"(at)momjian(dot)us, pgsql-hackers(at)postgresql(dot)org, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Subject: Re: visibility maps and heap_prune
Date: 2010-02-27 02:52:20
Message-ID: 201002270252.o1R2qKh09403@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Pavan Deolasee wrote:
> On Fri, Feb 26, 2010 at 8:19 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>
> >
> > Whatever happened to this? It was in the first 9.0 commitfest but was
> > returned with feedback but never updated:
> >
> >
> Though Alex did some useful tests and review, and in fact confirmed that the
> VACUUM time dropped from 16494 msec to 366 msec, I somehow kept waiting for
> Heikki's decision on the general direction of the patch and lost interest in
> between. If we are still interested in this, I can work out a patch and
> submit for next release if not this.

OK, TODO added:

Have single-page pruning update the visibility map
* https://commitfest.postgresql.org/action/patch_view?id=75

Hopefully Heikki can comment on this.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
PG East: http://www.enterprisedb.com/community/nav-pg-east-2010.do
+ If your life is a hard drive, Christ can be your backup. +

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2010-02-27 02:56:01 Re: Hot Standby query cancellation and Streaming Replication integration
Previous Message Greg Smith 2010-02-27 02:52:12 Re: Hot Standby query cancellation and Streaming Replication integration