Sequence failure after some time

From: "Jed Nicolau Filho" <jed(at)prouser(dot)com(dot)br>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Sequence failure after some time
Date: 2004-09-20 02:57:47
Message-ID: 001c01c49ebd$9c1efaa0$0e00a8c0@PROUSER.LOCALNET
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi there

I am doing a Stress Test in my app.
I have to clients connected into Postgre 8.0 using a sequence as PK generator.
Then two clients execute a login search a PK of generator that is placed in a table log
and logoff . This is executed in looping with 2 seconds delay between logon and logoff.

The problem is that for some minutes all work fine, then Postgre fail trying to generate PK in
a sequence !

How to fix it ?

Thanks in advance

Best Regards

Jed

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2004-09-20 05:00:14 NULL/0
Previous Message D. Stimits 2004-09-19 22:46:07 Re: import/export or moving data between databases