Re: [HACKERS] parallel restore item dependencies

2009-03-14 Thread Andrew Dunstan
Tom Lane wrote: I wrote: Andrew Dunstan writes: In my original patch, I looked at all the dependencies of a candidate item ansd compared them with the dependencies of the running items to see if there was a potential locking clash. However, Tom in his admirable reworking of my patc

Re: [HACKERS] parallel restore item dependencies

2009-03-13 Thread Tom Lane
I wrote: > Andrew Dunstan writes: >> In my original patch, I looked at all the dependencies of a candidate >> item ansd compared them with the dependencies of the running items to >> see if there was a potential locking clash. However, Tom in his >> admirable reworking of my patch, restricted t

Re: [HACKERS] parallel restore item dependencies

2009-03-11 Thread Tom Lane
Andrew Dunstan writes: > OK, I've worked out why I am seeing deadlocks etc. from parallel restore > on FK items. > In my original patch, I looked at all the dependencies of a candidate > item ansd compared them with the dependencies of the running items to > see if there was a potential lockin

[HACKERS] parallel restore item dependencies

2009-03-11 Thread Andrew Dunstan
OK, I've worked out why I am seeing deadlocks etc. from parallel restore on FK items. In my original patch, I looked at all the dependencies of a candidate item ansd compared them with the dependencies of the running items to see if there was a potential locking clash. However, Tom in his a