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

From Josh Berkus
Subject Re: Deadlocks? What happened to MVCC?
Date
Msg-id web-102244@davinci.ethosmedia.com
Whole thread Raw
In response to Re: Deadlocks? What happened to MVCC?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tom, Jan,

> MVCC does not mean "no locks" ... particularly not when UPDATEs are
> involved.  You'll need to be more specific about what your function
> is
> doing, but my first thought would be to look for the possibility of
> conflicting updates of the same row.

Found the problem after 3 hours and a phone call to PostgreSQL Inc.
Turns out that I had one too-broad UPDATE in a 250-line function ...
feh!

-Josh


______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: Tom Lane
Date:
Subject: Re: psql connection being reset during function?
Next
From: Paul McGarry
Date:
Subject: Temp tables being written to disk. Avoidable?