On 2015-11-02 15:37:57 -0500, Robert Haas wrote: > On Fri, Oct 30, 2015 at 9:49 AM, Vladimir Borodin <r...@simply.name> wrote: > > I’ve tried two ways - bare SELECT in autocommit mode and BEGIN; SELECT; > > ROLLBACK. I first described the problem in thread on pgsql-admin@ [0], there > > is copy-paste from psql there, but during conversation initial description > > was lost. > > > > [0] > > http://www.postgresql.org/message-id/7f74c5ea-6741-44fc-b6c6-e96f18d76...@simply.name > > Hmm. That behavior seems unexpected to me, but I might be missing something.
The conflict is because of a relation lock, not because of visibility. Hot-Standby feedback changes nothing about that. I presume all the other conflicts are all because of relation level locks? Check pg_stat_database_conflicts and the server logs to verify. Andres -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
