Known Bugs on Postgres 9.5

Anudeep Gudipelli <Anudeep.Gudipelli@AlticeUSA.com> writes:

I would like to know the known bugs for v9.5 and also v9.6, is there any place where I can check?

See release notes at

https://www.postgresql.org/docs/current/static/release.html

regards, tom lane

If you're using Postgres for Jira and Confluence, you should upgrade to
9.6. It is the newest version that is known to work. Version 9.5 will also
work but you will get better performance and longer life out of the 9.6
version.

Hi vick,

Is there any documentation on bugs, I can't find them on release notes. Based on the release notes I can see that 9.6 will perform better than 9.5, but I would like to know if there are any known bugs in both 9.5 and 9.6 . The reason is I need to present a business model to which version we can upgrade.

Thank you,
Anudeep

Get Outlook for iOS<https://aka.ms/o0ukef&gt;
________________________________
From: Vick Khera <vivek@khera.org>
Sent: Saturday, May 5, 2018 1:39:36 PM
To: Anudeep Gudipelli
Cc: pgsql-general@postgresql.org
Subject: Re: Known Bugs on Postgres 9.5

If you're using Postgres for Jira and Confluence, you should upgrade to 9.6. It is the newest version that is known to work. Version 9.5 will also work but you will get better performance and longer life out of the 9.6 version.

--------------------------------------------------------
Anudeep Gudipelli is a contractor, and not an employee of the company.
--------------------------------------------------------

--------------------------------------------------------
The information transmitted in this email and any of its attachments is intended only for the person or entity to which it is addressed and may contain information concerning Altice USA and/or its affiliates and subsidiaries that is proprietary, privileged, confidential and/or subject to copyright. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient(s) is prohibited and may be unlawful. If you received this in error, please contact the sender immediately and delete and destroy the communication and all of the attachments you have received and all copies thereof.
--------------------------------------------------------

On 05/05/2018 03:10 PM, Anudeep Gudipelli wrote:

Hi vick,

Is there any documentation on bugs, I can�t find them on release notes.
Based on the release notes I can see that 9.6 will perform better than
9.5, but I would like to know if there are any known bugs in both 9.5
and 9.6 . The reason is I need to present a business model to which
version we can upgrade.

Look at the release notes for 9.6. The descriptions for each item will
tell you what was added/changed or improved e.g.:

https://www.postgresql.org/docs/10/static/release-9-6.html

"
E.13.3.1.11. Reliability

Force backends to exit if the postmaster dies (Rajeev Rastogi,
Robert Haas)

Under normal circumstances the postmaster should always outlive its
child processes. If for some reason the postmaster dies, force backend
sessions to exit with an error. Formerly, existing backends would
continue to run until their clients disconnect, but that is unsafe and
inefficient. It also prevents a new postmaster from being started until
the last old backend has exited. Backends will detect postmaster death
when waiting for client I/O, so the exit will not be instantaneous, but
it should happen no later than the end of the current query.
"

Changes are back ported to current supported versions that have the same
feature, so if was fixed in 9.6 and existed in 9.5 it was fixed there
also. That would cover fixed bugs up to the last minor release. As to
what is being worked on for the next minor release you will need to wade
through the archives here:

https://www.postgresql.org/list/pgsql-bugs/

Know that there is a regular regular cycle for bug fixes:

https://www.postgresql.org/developer/roadmap/

If there is a show stopper bug a release will happen between the
scheduled dates .

Thank you,
Anudeep

--
Adrian Klaver
adrian.klaver@aklaver.com

On 05/05/2018 03:10 PM, Anudeep Gudipelli wrote:

Hi vick,

Is there any documentation on bugs, I can�t find them on release notes.
Based on the release notes I can see that 9.6 will perform better than
9.5, but I would like to know if there are any known bugs in both 9.5
and 9.6 . The reason is I need to present a business model to which
version we can upgrade.

Should have mentioned in previous post the way I keep up with Postgres
development(wrt to bugs/fixes), PostgreSQL Weekly News on the --announce
list:

https://www.postgresql.org/list/pgsql-announce/

Example:

/messages/by-id/20180429222104.GA25267@fetter.org

Scroll down to the the Applied Patches and/or Pending Patches section(s).

Thank you,
Anudeep

--
Adrian Klaver
adrian.klaver@aklaver.com

On Friday, May 4, 2018, Anudeep Gudipelli <Anudeep.Gudipelli@alticeusa.com>
wrote:

I would like to know the known bugs for v9.5 and also v9.6, is there any
place where I can check?

I think as a whole the project does a good job of fixing known bugs shortly
after they are reported.

There is no official bug tracker (i.e., maintained by committers), for
better and worse, though the commitfest application does occasionally track
some, though usually those are cutting edge.

If you want an opinion, opting for more than one release behind current on
fear grounds is an ultra-conservative position - you might as well minimize
the pain and go recent and keep it longer. At this point I'd be asking
myself whether 9.6 or 10 is the better choice. Though with a third-party
application that runs on top of it I'd probably limit myself to the highest
release they purport to support.

David J.

On Sat, May 5, 2018 at 7:49 PM, David G. Johnston <
david.g.johnston@gmail.com> wrote:

If you want an opinion, opting for more than one release behind current on
fear grounds is an ultra-conservative position - you might as well minimize
the pain and go recent and keep it longer. At this point I'd be asking
myself whether 9.6 or 10 is the better choice. Though with a third-party
application that runs on top of it I'd probably limit myself to the highest
release they purport to support.

Precisely why I suggest 9.6