From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: postgresql : could not serialize access due to read/write dependencies among transactions |
Date: | 2017-01-18 05:10:27 |
Message-ID: | ffd51bc2-0639-8dfd-9246-7ab29dd74905@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
On 1/17/2017 8:54 PM, Neslisah Demirci wrote:
>
>
> could not serialize access due to read/write dependencies among
> transactions
>
only way to answer this would be to know what the various concurrent
transactions are doing.
> A message app like whatsapp i decided to use isolation level
> serializable if i use other transaction levels many conversations
> started with same number (think about whatsapp web sidebar multipling
> with same number every message).
again, we'd need to know what your transactions are doing. what you're
describing sounds inherently incorrect, like you're doing too much in
the application and not enough in the database
> I also add an index to my query and my query's execution plan don't
> use seq scan .
>
that has no bearing on the above problems.
--
john r pierce, recycling bits in santa cruz
From | Date | Subject | |
---|---|---|---|
Next Message | Sankaranarayanan, Srinivasan | 2017-01-18 10:24:33 | Re: Ora2PG configuration |
Previous Message | Neslisah Demirci | 2017-01-18 04:54:49 | postgresql : could not serialize access due to read/write dependencies among transactions |
From | Date | Subject | |
---|---|---|---|
Next Message | Neslisah Demirci | 2017-01-18 05:41:54 | Ynt:postgresql : could not serialize access due to read/write dependencies among transactions |
Previous Message | Neslisah Demirci | 2017-01-18 04:54:49 | postgresql : could not serialize access due to read/write dependencies among transactions |