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

Поиск
Список
Период
Сортировка
От Dean Rasheed
Тема Re: Scaling up deferred unique checks and the after trigger queue
Дата
Msg-id 8e2dbb700910261023j5c4e9ae4j7efa3e10ba02c39f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Scaling up deferred unique checks and the after trigger queue  (Jeff Davis <pgsql@j-davis.com>)
Ответы Re: Scaling up deferred unique checks and the after trigger queue
Список 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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: a question about relkind of RelationData handed over to heap_update function
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Parsing config files in a directory