64-bit CommandIds

From: Zoltan Boszormenyi <zb(at)cybertec(dot)at>
To: pgsql-patches <pgsql-patches(at)postgresql(dot)org>
Cc: Hans-Juergen Schoenig <hs(at)cybertec(dot)at>
Subject: 64-bit CommandIds
Date: 2008-03-04 17:27:01
Message-ID: 47CD8665.7070903@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hi,

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.

The feature is off by default, you need to --enable-huge-commandid.
It fails only one regression test (without_oid) that measures the saved
space in 8.3.

Also, modifying FirstCommandId to be (1<<32ULL - 4) to early overflow
the 32-bit limit) doesn't show any real problem besides the combocid
regression failure that explicitly lists cmin/cmax values, which is
expected.

It was written by Zoltán Böszörményi <zb(at)cybertec(dot)at> and
Hans-Jürgen Schönig <hs(at)cybertec(dot)at>

Best regards,
Zoltán Böszörményi

--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/

Attachment Content-Type Size
pg84-64-bit-cmdid.patch text/x-patch 15.5 KB

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2008-03-04 17:41:10 Re: 64-bit CommandIds
Previous Message Magnus Hagander 2008-03-04 15:40:34 Re: Fix for initdb failures on Vista