Re: [BUGS] BUG #14635: Query is executed slower on hot standby slave database then on master database - Mailing list pgsql-bugs

From Tom Lane
Subject Re: [BUGS] BUG #14635: Query is executed slower on hot standby slave database then on master database
Date
Msg-id 28812.1496088429@sss.pgh.pa.us
Whole thread Raw
In response to Re: [BUGS] BUG #14635: Query is executed slower on hot standby slavedatabase then on master database  (Jeff Janes <jeff.janes@gmail.com>)
List 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 by date:

Previous
From: lsichello@illumina.com
Date:
Subject: [BUGS] BUG #14677: BLOCKER: Postgres 9.4.12 repos only presenting packagesfor RHEL7
Next
From: Daniele Varrazzo
Date:
Subject: [BUGS] [PATCH] Fixed malformed error message on malformed SCRAM message.