Re: 64-bit CommandIds - Mailing list pgsql-patches

From Hans-Juergen Schoenig
Subject Re: 64-bit CommandIds
Date
Msg-id 48118402.9050009@cybertec.at
Whole thread Raw
In response to Re: 64-bit CommandIds  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: 64-bit CommandIds  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-patches
Alvaro Herrera wrote:
> Bruce Momjian wrote:
>
>
>>> I think the case for it got a whole lot weaker in 8.3, with lazy
>>> consumption of CIDs.
>>>
>> Agreed.  Let's see if we get requests for it in >= 8.3 releases.
>>
>
> In the original submission message you find this text:
>
> : attached is our patch against HEAD which enables extending CommandIds
> : to 64-bit. This is for enabling long transactions that really do that
> : much non-read-only work in one transaction.
>
> Question for Hans-Juergen and Zoltan: have you tested 8.3 and do you
> still see the need for this?
>
>

good morning,

i have seen this problem two or three times within the past 2-3 years or
so. so, it can basically happen in the field for some special purpose
applications but i don't see this as an every day problem. it would be
nice to have it in.
we could also go for some special contrib module which could contain a
patch along with some documentation but i am not quite sure how this
fits in there.
we would of course maintain the patch.

    many thanks,

       hans

--
Cybertec Schönig & Schönig GmbH
PostgreSQL Solutions and Support
Gröhrmühlgasse 26, A-2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql-support.de, www.postgresql-support.com


pgsql-patches by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Improve shutdown during online backup, take 4
Next
From: Tom Lane
Date:
Subject: Re: Improve shutdown during online backup, take 4