Re: Idea for getting rid of VACUUM FREEZE on cold pages

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Josh Berkus" <josh(at)agliodbs(dot)com>,"Jesper Krogh" <jesper(at)krogh(dot)cc>
Cc: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Idea for getting rid of VACUUM FREEZE on cold pages
Date: 2010-05-27 19:15:56
Message-ID: 4BFE7E9C0200002500031B89@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jesper Krogh <jesper(at)krogh(dot)cc> wrote:

> Couldn't pages that are totally filled by the same transaction, be

> frozen on the initial write?

As far as I'm aware, that can only be done if:

(a) The tuples were written within the same transaction which
created or truncated the table.

*or*

(b) The writing transaction and all transactions concurrent to it
have completed by the time the page is about to be written.

-Kevin

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message alvherre 2010-05-27 19:29:28 Re: List traffic
Previous Message Stephen Frost 2010-05-27 19:12:08 Re: [RFC] Security label support