Re: [BUGS] BUG #14635: Query is executed slower on hot standby slave database then on master database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] BUG #14635: Query is executed slower on hot standby slave database then on master database
Дата
Msg-id 28812.1496088429@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [BUGS] BUG #14635: Query is executed slower on hot standby slavedatabase then on master database  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-bugs
Jeff Janes <jeff.janes@gmail.com> writes:
> But why can't the same mechanisms used on tables work on indexes, which is
> to wait out or conflict out any too-old transactions on the standby?  Is
> there a fundamental reason for that, or just that no one got around to
> implementing it?

I think it's probably do-able, but not exactly trivial.  The existing
behavior was an expedient solution when we were first getting hot standby
to work at all.  Seems like it may be time to go back and improve it.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

В списке pgsql-bugs по дате отправления:

Предыдущее
От: lsichello@illumina.com
Дата:
Сообщение: [BUGS] BUG #14677: BLOCKER: Postgres 9.4.12 repos only presenting packagesfor RHEL7
Следующее
От: Daniele Varrazzo
Дата:
Сообщение: [BUGS] [PATCH] Fixed malformed error message on malformed SCRAM message.