From: | Vladimir Borodin <root(at)simply(dot)name> |
---|---|
To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | Oleksii Kliukin <alexk(at)hintbits(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] Replication slots and isolation levels |
Date: | 2015-11-03 06:57:52 |
Message-ID: | A408EACD-71C8-4699-A0E7-92ADD00F3817@simply.name |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers |
> 2 нояб. 2015 г., в 23:37, Robert Haas <robertmhaas(at)gmail(dot)com> написал(а):
>
> On Fri, Oct 30, 2015 at 9:49 AM, Vladimir Borodin <root(at)simply(dot)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-E96F18D761FB@simply.name
>
> Hmm. That behavior seems unexpected to me, but I might be missing something.
Me too. That’s why I started the thread. One small detail that might have a value is that the big table being queried is partitioned into 64 inhereted tables. Now I’m trying to write a simple script to reproduce the problem, but that is not so easy because AFAIK VACUUM on master should happen while single query on standby is running and it should vacuum those rows that have not been accessed by the query on standby yet.
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
--
May the force be with you…
https://simply.name
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2015-11-03 08:38:42 | Re: [ADMIN] Replication slots and isolation levels |
Previous Message | Jorge Torralba | 2015-11-03 00:39:02 | pg_upgrade with --link then pg_basebackup for replication |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2015-11-03 07:12:57 | Re: Patent warning about the Greenplum source code |
Previous Message | Petr Jelinek | 2015-11-03 06:30:16 | Re: WIP: Rework access method interface |