From: | Thomas O'Dowd <tom(at)nooper(dot)com> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Looking for foreign key guinea pigs |
Date: | 2002-10-16 03:43:30 |
Message-ID: | 1034739809.23530.79.camel@beast.uwillsee.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Stephan,
Sounds good. I might be able to help you out with those tests as I'd
love this problem to be fixed. I actually removed all RI and replaced
them with triggers because of the problems I was having. I might be a
bit slow getting back to you each time though as my plate is pretty
full. You can grab me off-list for more info.
Tom.
On Wed, 2002-10-16 at 12:25, Stephan Szabo wrote:
> 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. :)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
--
Thomas O'Dowd - A Noop a day, helps you work rest and play!
tom(at)nooper(dot)com - http://nooper.co.jp
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Bartley | 2002-10-16 04:43:19 | Re: Looking for foreign key guinea pigs |
Previous Message | Stephan Szabo | 2002-10-16 03:25:14 | Looking for foreign key guinea pigs |