Looking for foreign key guinea pigs

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Looking for foreign key guinea pigs
Date: 2002-10-16 03:25:14
Message-ID: 20021015201013.H89100-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I'm looking to see if anyone has
a) a development/testing server they don't mind
testing very early pre-development stuff on
b) foreign key systems (using no action) that
currently have deadlocking or waiting problems
c) can run realistic requests that have deadlocked
the current triggers
d) willingness to help with debugging

I'm in very preliminary stages of trying out the
dirty read-for update barrier code in a fashion
that appears to work better in regards to locking
than what we currently have, but I only have
simple tests to run from multiple psqls
interactively right now.

I'm not sure that the no action cases (all I've
converted at the moment) are working 100% to
both not lock as badly and still maintain the
correct semantics and looking for some brave
souls to help. :)

In any case, I'm still days (at the 1/2 hour
a day I tend to get to work on it) away from
having a patch form I'm comfortable with.

If anyone's interested in helping reply here
or directly. :)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas O'Dowd 2002-10-16 03:43:30 Re: Looking for foreign key guinea pigs
Previous Message Bruce Momjian 2002-10-16 03:19:09 Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.)