Deadlocks? What happened to MVCC? - Mailing list pgsql-sql

From Josh Berkus
Subject Deadlocks? What happened to MVCC?
Date
Msg-id web-102047@davinci.ethosmedia.com
Whole thread Raw
Responses Re: Deadlocks? What happened to MVCC?
Re: Deadlocks? What happened to MVCC?
List pgsql-sql
Folks:

I'm getting deadlock errors on one of the operations on my web
application.  It's a function which adds a large number of rows to a
holding table, then updates that set of rows multiple times in order to
present scoring information to the user.

However, the function is deadlocking itself once it's in heavy use.  I
though that MVCC was supposed to supercede deadlocks, unless I
specifically set locks, which I'm not.

Help, anyone?

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________                                      Josh Berkus Complete
informationtechnology      josh@agliodbs.com  and data management solutions       (415) 565-7293 for law firms, small
businesses       fax 621-2533   and non-profit organizations.      San Francisco
 


pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: DateDiff, IsNull?
Next
From: Gary Stainburn
Date:
Subject: Re: Re: Are circular REFERENCES possible ?