Re: Deadlocks? What happened to MVCC?

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: Deadlocks? What happened to MVCC?
Дата
Msg-id web-102244@davinci.ethosmedia.com
обсуждение исходный текст
Ответ на Re: Deadlocks? What happened to MVCC?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: psql connection being reset during function?
Следующее
От: Paul McGarry
Дата:
Сообщение: Temp tables being written to disk. Avoidable?