Re: Slow concurrent processing
От | Jeff Janes |
---|---|
Тема | Re: Slow concurrent processing |
Дата | |
Msg-id | CAMkU=1zune_RMF=2k46b_QwJ6C=E73deNzixSmEfdyd7ORGa3A@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Slow concurrent processing (Misa Simic <misa.simic@gmail.com>) |
Ответы |
Re: Slow concurrent processing
|
Список | pgsql-performance |
On Tue, Mar 12, 2013 at 7:13 AM, Misa Simic <misa.simic@gmail.com> wrote:
Unless you are running an ancient version of PostgreSQL (<8.1), this would no longer pose a problem.
Cheers,
Jeff
Hi,Researching deeply my problem with concurrent processing i have found:"The more likely suspect is a foreign key conflict.Are both transactions inserting/updating rows that could referencethe same row(s) in a master table?" - Tom LaneThis 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
В списке pgsql-performance по дате отправления: