Sequence failure after some time

Поиск
Список
Период
Сортировка
От Jed Nicolau Filho
Тема Sequence failure after some time
Дата
Msg-id 001c01c49ebd$9c1efaa0$0e00a8c0@PROUSER.LOCALNET
обсуждение исходный текст
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "Bill Jacaruso"
Дата:
Сообщение: Austin User Group
Следующее
От: Walter Haslbeck
Дата:
Сообщение: Moving table from one schema to another