Re: [GENERAL] 9.1 causing "out of shared memory" error and higher serialization conflicts

2012-03-09 Thread Francisco Figueiredo Jr.
; > *From:* francisco.figueiredo...@gmail.com [mailto: > francisco.figueiredo...@gmail.com] *On Behalf Of *Francisco Figueiredo Jr. > *Sent:* Friday, March 09, 2012 12:41 PM > *To:* Randy Ficker > *Cc:* Marti Raudsepp; pgsql-general@postgresql.org > *Subject:* RE: [GENERAL] 9.1 causing &q

Re: [GENERAL] 9.1 causing "out of shared memory" error and higher serialization conflicts

2012-03-09 Thread Randy Ficker
edo...@gmail.com] On Behalf Of Francisco Figueiredo Jr. Sent: Friday, March 09, 2012 12:41 PM To: Randy Ficker Cc: Marti Raudsepp; pgsql-general@postgresql.org Subject: RE: [GENERAL] 9.1 causing "out of shared memory" error and higher serialization conflicts Would you mind to fill a bug rep

Re: [GENERAL] 9.1 causing "out of shared memory" error and higher serialization conflicts

2012-03-09 Thread Francisco Figueiredo Jr.
h 09, 2012 10:36 AM > *To:* Randy Ficker > *Cc:* pgsql-general@postgresql.org; Marti Raudsepp > *Subject:* Re: [GENERAL] 9.1 causing "out of shared memory" error and > higher serialization conflicts > > ** ** > > > Thanks for the heads up. > &

Re: [GENERAL] 9.1 causing "out of shared memory" error and higher serialization conflicts

2012-03-09 Thread Randy Ficker
, March 09, 2012 10:36 AM To: Randy Ficker Cc: pgsql-general@postgresql.org; Marti Raudsepp Subject: Re: [GENERAL] 9.1 causing "out of shared memory" error and higher serialization conflicts Thanks for the heads up. I'll fix that in Npgsql so it sends the correct isolation level

Re: [GENERAL] 9.1 causing "out of shared memory" error and higher serialization conflicts

2012-03-09 Thread Francisco Figueiredo Jr.
I'm > going to fix this right away. Thanks for the reply! > > -Original Message- > From: Marti Raudsepp [mailto:ma...@juffo.org] > Sent: Friday, March 09, 2012 9:41 AM > To: Randy Ficker > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] 9.1 cau

Re: [GENERAL] 9.1 causing "out of shared memory" error and higher serialization conflicts

2012-03-09 Thread Randy Ficker
after all. I'm going to fix this right away. Thanks for the reply! -Original Message- From: Marti Raudsepp [mailto:ma...@juffo.org] Sent: Friday, March 09, 2012 9:41 AM To: Randy Ficker Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] 9.1 causing "out of shared memory"

Re: [GENERAL] 9.1 causing "out of shared memory" error and higher serialization conflicts

2012-03-09 Thread Marti Raudsepp
On Fri, Mar 9, 2012 at 19:16, Randy Ficker wrote: > Most writing transactions are using the REPEATABLE READ isolation > level (the SERIALIZABLE level is not used at all). Are you 100% sure about this? A major thing that changed in 9.1 was implementation for proper SERIALIZABLE isolation, which co

[GENERAL] 9.1 causing "out of shared memory" error and higher serialization conflicts

2012-03-09 Thread Randy Ficker
Hello, I recently upgraded my production database from 8.4 to 9.1. Ever since the upgrade, I'm seeing a ton of "out of shared memory" errors as well as a drastically increased quantity of serialization conflicts ("could not serialize access due to read/write dependencies among transactions" er