Re: Slow concurrent processing

:(

Ah - 9.1.0 is postgres version on Ubuntu...

Thanks Jeff - you saved me some time - reorganising functions to work with
different tables would take time... what potentially will not give us
solution :(

Many thanks,

Misa

2013/3/12 Jeff Janes <jeff(dot)janes(at)gmail(dot)com>

> On Tue, Mar 12, 2013 at 7:13 AM, Misa Simic <misa(dot)simic(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> Researching deeply my problem with concurrent processing i have found:
>>
>>
>> http://postgresql.1045698.n5.nabble.com/WHY-transaction-waits-for-another-transaction-tp2142627p2142630.html
>>
>>
>> "The more likely suspect is a foreign key conflict.
>> Are both transactions inserting/updating rows that could reference
>> the same row(s) in a master table?" - Tom Lane
>>
>> This is exactly the case (in my case) - several connections tries to
>> insert rows in the same table... but some columns are referenced to
>> settings tables... and there is possibility that two rows what we want to
>> insert reference the same row in settings table...
>>
>
> Unless you are running an ancient version of PostgreSQL (<8.1), this would
> no longer pose a problem.
>
> Cheers,
>
> Jeff
>