Skip site navigation (1) Skip section navigation (2)

Re: Scaling up deferred unique checks and the after trigger queue

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)googlemail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Scaling up deferred unique checks and the after trigger queue
Date: 2009-10-26 16:59:25
Message-ID: 1256576365.14045.0.camel@jdavis (view raw or flat)
Thread:
Lists: pgsql-hackers
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.

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

I'll keep looking into it.

Thanks,
	Jeff Davis



In response to

Responses

pgsql-hackers by date

Next:From: Dean RasheedDate: 2009-10-26 17:11:06
Subject: Re: Scaling up deferred unique checks and the after trigger queue
Previous:From: Joshua D. DrakeDate: 2009-10-26 16:55:52
Subject: Re: table corrupted

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group