From: John R Pierce <pierce@hogranch.com>
To: pgsql-general@postgresql.org
Subject: Re: postgresql : could not serialize access due to read/write dependencies among transactions
Date: Tue, 17 Jan 2017 21:10:27 -0800
Message-ID: <ffd51bc2-0639-8dfd-9246-7ab29dd74905@hogranch.com> (raw)
In-Reply-To: <AM5PR0501MB2433DC840DADE96339CACF6E9B7F0@AM5PR0501MB2433.eurprd05.prod.outlook.com>
References: <AM5PR0501MB2433DC840DADE96339CACF6E9B7F0@AM5PR0501MB2433.eurprd05.prod.outlook.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: pierce@hogranch.com, pgsql-general@postgresql.org
Subject: Re: postgresql : could not serialize access due to read/write dependencies among transactions
In-Reply-To: <ffd51bc2-0639-8dfd-9246-7ab29dd74905@hogranch.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox