Re: Lock contention in TransactionIdIsInProgress()

Started by Tomáš Ukoover 9 years ago4 messagesgeneral
Jump to latest
#1Tomáš Uko
uko@avast.com

Hi Jeff,

We have encountered same problem as you (in 9.5.4), it seems that so far it
hasn’t been ported back from 9.6, but if you take this commit and apply it
to 9.5 source codes, it seems to be working

But anyway, does anybody knows plans about backporting this to 9.5 official
way?

Regards

Tomas

#2Merlin Moncure
mmoncure@gmail.com
In reply to: Tomáš Uko (#1)

On Wed, Oct 5, 2016 at 5:38 AM, Tomáš Uko <uko@avast.com> wrote:

Hi Jeff,

We have encountered same problem as you (in 9.5.4), it seems that so far it
hasn’t been ported back from 9.6, but if you take this commit and apply it
to 9.5 source codes, it seems to be working

But anyway, does anybody knows plans about backporting this to 9.5 official
way?

Won't happen. Only bugs get ported back, and performance enhancements
generally don't qualify (in very exceptional cases they might but this
issue is a routine performance enhancement). Basically you have to
decide to update or stay with 9.5.

merlin

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

#3Michael Paquier
michael@paquier.xyz
In reply to: Merlin Moncure (#2)

On Fri, Oct 7, 2016 at 10:36 PM, Merlin Moncure <mmoncure@gmail.com> wrote:

On Wed, Oct 5, 2016 at 5:38 AM, Tomáš Uko <uko@avast.com> wrote:

Hi Jeff,

We have encountered same problem as you (in 9.5.4), it seems that so far it
hasn’t been ported back from 9.6, but if you take this commit and apply it
to 9.5 source codes, it seems to be working

But anyway, does anybody knows plans about backporting this to 9.5 official
way?

Won't happen. Only bugs get ported back, and performance enhancements
generally don't qualify (in very exceptional cases they might but this
issue is a routine performance enhancement). Basically you have to
decide to update or stay with 9.5.

Another possibility is to patch and build yourself Postgres if you are
still willing to use that with a given version. But as that's actually
forking the upstream version, it won't be supported by community.
--
Michael

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

#4Andres Freund
andres@anarazel.de
In reply to: Merlin Moncure (#2)

On 2016-10-07 08:36:12 -0500, Merlin Moncure wrote:

Won't happen. Only bugs get ported back

Hopefully we don't port bugs back all that often.

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