Re: [GENERAL] Large amount of serialization errors in transactions

2013-05-15 Thread Kevin Grittner
Vegard Bønes wrote: > I tried increasing max_pred_locks_per_transaction by a factor 20, > and that seems to have helped. Good to know.  After I sent my response I was hoping you wouldn't take it to imply that increating it by a factor of 10 was necessarily the useful maximum.  It depends mostly

Re: [GENERAL] Large amount of serialization errors in transactions

2013-05-14 Thread Vegard Bønes
quot; Til: "Vegard Bønes" , pgsql-general@postgresql.org Sendt: 10. mai 2013 20:35:05 Emne: Re: [GENERAL] Large amount of serialization errors in transactions Vegard Bønes wrote: > I have a problem understanding how transactions with serializable > isolation level works in postgresql

Re: [GENERAL] Large amount of serialization errors in transactions

2013-05-10 Thread Kevin Grittner
Vegard Bønes wrote: > I have a problem understanding how transactions with serializable > isolation level works in postgresql. What exactly may cause a > serialization error? A pattern of read-write dependencies among concurrent transactions which indicate that a serialization anomaly is possibl

[GENERAL] Large amount of serialization errors in transactions

2013-05-10 Thread Vegard Bønes
Hi! I have a problem understanding how transactions with serializable isolation level works in postgresql. What exactly may cause a serialization error? My problem is a system where process one adds data to a database. Shortly afterwards, process two reads and possibly modifies the same data (k