Re: [PERFORM] deadlock_timeout affect on performance

2012-10-02 Thread Heikki Linnakangas
On 01.10.2012 19:49, pg noob wrote: Hi all, I have a question about the deadlock_timeout in regards to performance. Right now we have this timeout set at its default of 1s. My understanding of it is that this means that every 1 second the server will check for deadlocks. Not quite. It means th

[PERFORM] deadlock_timeout affect on performance

2012-10-02 Thread pg noob
Hi all, I have a question about the deadlock_timeout in regards to performance. Right now we have this timeout set at its default of 1s. My understanding of it is that this means that every 1 second the server will check for deadlocks. What I am wondering is how much of a performance improvement w