support for hyper-long transactions ...

From: Hans-Juergen Schoenig <postgres(at)cybertec(dot)at>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: support for hyper-long transactions ...
Date: 2007-10-16 12:16:13
Message-ID: 555FDCB5-97B4-4752-A936-AEE6B82C7697@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

at the moment i am working on an application which is supposed to run
extremely large transactions (a lot of server side stored procedure
stuff which can hardly be split into small transactions for
visibility reasons).
so, from time to time it happens that i exceed my CommandCounter (>
2.000.000.000 statements inside the same transaction).

my idea is: how about adding a configure option to compile postgres
with a 64 bit command counter. this would allow larger transactions
for special purpose applications while it would not have an impact on
normal applications.

comments are welcome ...

best regards,

hans

--
Cybertec Schönig & Schönig GmbH
Gröhrmühlgasse 26, 2700 Wiener Neustadt
Tel: +43/1/205 10 35 / 340
www.postgresql.at, www.cybertec.at

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2007-10-16 12:39:37 Re: support for hyper-long transactions ...
Previous Message Magnus Hagander 2007-10-16 11:30:16 pgsql: Re-allow UTF8 encodings on win32.