Home > mailing lists

Sequence failure after some time - Mailing list pgsql-general

From	Jed Nicolau Filho
Subject	Sequence failure after some time
Date	September 26, 2004 23:22:51
Msg-id	001c01c49ebd$9c1efaa0$0e00a8c0@PROUSER.LOCALNET Whole thread Raw
List	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

From: "Bill Jacaruso"
Date: 26 September 2004, 23:22:46
Subject: Austin User Group

From: Walter Haslbeck
Date: 26 September 2004, 23:22:59
Subject: Moving table from one schema to another