Re: Proposal for CSN based snapshots - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Proposal for CSN based snapshots
Date
Msg-id CA+TgmoZ4cP_1Pavwn+VX74_ksDhHf-whO5FFR1j+NdZqONu8MA@mail.gmail.com
Whole thread Raw
In response to Re: Proposal for CSN based snapshots  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Responses Re: Proposal for CSN based snapshots  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
On Fri, May 30, 2014 at 2:38 PM, Heikki Linnakangas
<hlinnakangas@vmware.com> wrote:
> (forgot to answer this question)
>
> On 05/30/2014 06:27 PM, Andres Freund wrote:
>>
>> On 2014-05-30 17:59:23 +0300, Heikki Linnakangas wrote:
>>>
>>> * I expanded pg_clog to 64-bits per XID, but people suggested keeping
>>> pg_clog as is, with two bits per commit, and adding a new SLRU for the
>>> commit LSNs beside it. Probably will need to do something like that to
>>> avoid
>>> bloating the clog.
>>
>>
>> It also influences how on-disk compatibility is dealt with. So: How are
>> you planning to deal with on-disk compatibility?
>
>
> Have pg_upgrade read the old clog and write it out in the new format.

That doesn't address Bruce's concern about CLOG disk consumption.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Abhijit Menon-Sen
Date:
Subject: Re: idle_in_transaction_timeout
Next
From: David G Johnston
Date:
Subject: Re: Re-create dependent views on ALTER TABLE ALTER COLUMN ... TYPE?