[HACKERS] support for hyper-long transactions ...

2007-10-16 Thread Hans-Juergen Schoenig
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 (

Re: [HACKERS] support for hyper-long transactions ...

2007-10-16 Thread Heikki Linnakangas
Hans-Juergen Schoenig wrote: 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

Re: [HACKERS] support for hyper-long transactions ...

2007-10-16 Thread Heikki Linnakangas
Hans-Juergen Schoenig wrote: 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

Re: [HACKERS] support for hyper-long transactions ...

2007-10-16 Thread Zoltan Boszormenyi
Heikki Linnakangas írta: Hans-Juergen Schoenig wrote: 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

Re: [HACKERS] support for hyper-long transactions ...

2007-10-16 Thread Hans-Juergen Schoenig
AFAICS, maximum number of command ids is actually 2^32-1, or over 4 billion. Are you sure you bumped into that limit and not something else? What's the error message you're getting? What version of Postgres is this? PG 8.3 will have another related limit on the number of combocids you can