Re: Transaction Snapshots and Hot Standby

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
Cc: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Transaction Snapshots and Hot Standby
Date: 2008-09-15 09:40:15
Message-ID: 1221471615.3913.1238.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


On Sat, 2008-09-13 at 10:48 +0100, Florian G. Pflug wrote:

> The main idea was to invert the meaning of the xid array in the snapshot
> struct - instead of storing all the xid's between xmin and xmax that are
> to be considering "in-progress", the array contained all the xid's >
> xmin that are to be considered "completed".

> The downside is that the size of the read-only snapshot is theoretically
> unbounded, which poses a bit of a problem if it's supposed to live
> inside shared memory...

Why do it inverted? That clearly has problems.

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tatsuo Ishii 2008-09-15 09:46:16 Re: Common Table Expressions (WITH RECURSIVE) patch
Previous Message Simon Riggs 2008-09-15 09:26:40 Re: rmgr hooks and contrib/rmgr_hook