Re: HOT patch - version 15 - Mailing list pgsql-patches

From Heikki Linnakangas
Subject Re: HOT patch - version 15
Date
Msg-id 46E03A43.9000300@enterprisedb.com
Whole thread Raw
In response to Re: HOT patch - version 15  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: HOT patch - version 15  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: HOT patch - version 15  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Alvaro Herrera wrote:
> Heikki Linnakangas escribió:
>
>> Hmm. I wonder if we could prune/defragment in bgwriter?
>
> That would be best, if at all possible.  You can prune without accessing
> anything outside the page itself, right?

Yes, though you do need to have an oldest xmin to determine which tuples
are dead, and the removed tuples need to be WAL-logged.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

pgsql-patches by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: HOT patch - version 15
Next
From: Alvaro Herrera
Date:
Subject: Re: HOT patch - version 15