Re: [HACKERS] Advice: Where could I be of help?

On Sat, Oct 05, 2002 at 03:53:47PM +0900, Thomas O'Dowd wrote:
> > just an idea,  but if you're still searching something to work on, you might want to take
> > a look on the deadlock problem with foreign keys. It seems there's a new kind of lock needed here,
> > because it's possible to deadlock backends where no real deadlock situation occurs.
> >
> > IMO this is one of the biggest problems in postgres now, because for foreign keys are widely used and
> > - even if not deadlocking - performance is limited because of the many "select ... for update" the fk system
> > uses limit concurrency to one at a time in many situations.
>
> That gets my vote too for what its worth... I had to remove most of the
> FK references from my tables and just replaced them with triggers as the
> amount of deadlocks I was getting in stress tests was killing me.

 <jog-to-developers>
    ... maybe try use latest MySQL with InnoDB tables :-)
 </jog-to-developers>

    Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/

 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz