Re: Scaling up deferred unique checks and the after trigger queue - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: Scaling up deferred unique checks and the after trigger queue
Date
Msg-id 8e2dbb700910261023j5c4e9ae4j7efa3e10ba02c39f@mail.gmail.com
Whole thread Raw
In response to Re: Scaling up deferred unique checks and the after trigger queue  (Jeff Davis <pgsql@j-davis.com>)
Responses Re: Scaling up deferred unique checks and the after trigger queue
List pgsql-hackers
2009/10/26 Jeff Davis <pgsql@j-davis.com>:
> On Mon, 2009-10-26 at 13:41 +0000, Dean Rasheed wrote:
>> I did a quick bit of testing, and I think that there is a
>> locking/concurrency problem :-(
>
> Unfortunately I can't reproduce the problem on my machine; it always
> passes.
>

That's odd. It happens every time on my machine (10 threads, 1000 loops).

> If you have a minute, can you try to determine if the problem can happen
> with a non-deferrable constraint?
>

If anything, that seems to make it fail more quickly.

If it's of any relevance, I'm currently using an optimised build, with
assert checking off.
[Linux x86_64, 2 core Intel Core2]
- Dean


pgsql-hackers by date:

Previous
From: Greg Stark
Date:
Subject: Re: a question about relkind of RelationData handed over to heap_update function
Next
From: Robert Haas
Date:
Subject: Re: Parsing config files in a directory