From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, "A(dot)Bhuvaneswaran" <bhuvanbk(at)yahoo(dot)com>, Jan Wieck <JanWieck(at)yahoo(dot)com>, Kevin Brown <kevin(at)sysexperts(dot)com>, <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Heads up: 7.3.3 this Wednesday |
Date: | 2003-05-20 15:31:50 |
Message-ID: | Pine.LNX.4.33.0305200930420.20961-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
On Mon, 19 May 2003, Tom Lane wrote:
> "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> writes:
> >> This deadlocks in 7.3, but works in CVS tip.
>
> > Hmmm...I suspect this will remove a lot of the FK deadlocks I see in my logs
> > all the time...does seem like a bug doesn't it?
>
> Yeah. I'm just worried that there might be some downside we've not
> spotted yet. I'd feel better about it if *anyone* had reported
> successful production use of the patch in the month since it's been
> available. I thought one or two people had expressed the intention
> to run the patch when Jan offered it ... where are they?
I'd be glad to test it, but we don't have any issues with fk deadlocks
since our load is 99% read, 1% write, and most of the tables with fks on
them only have a handful of writers, so any testing I would do would
probably just be the "we used it in production and it didn't die" kind of
testing.
From | Date | Subject | |
---|---|---|---|
Next Message | Kaare Rasmussen | 2003-05-20 15:34:08 | Re: Calling external program from trigger |
Previous Message | Jan Wieck | 2003-05-20 15:25:22 | Re: Calling external program from trigger |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-05-20 15:54:11 | Re: Heads up: 7.3.3 this Wednesday |
Previous Message | Christopher Browne | 2003-05-20 11:16:21 | Re: Heads up: 7.3.3 this Wednesday |