Обсуждение: Known Bugs on Postgres 9.5
Hi Team,
I am writing this email regarding Postgres 9.5 version, I found that you are one of the professional services in North America.
I am JIRA and Confluence administrator in my organization and we are planning to upgrade these both instance, while investigation I found that our current Postgres 9.3 database support end of life is September 2018, My organization is planning to upgrade to Postgres v9.5 which can support 2 years from now. I would like to know the known bugs for v9.5 and also v9.6, is there any place where I can check?
I appreciate your help!
Thank you,
Anudeep
--------------------------------------------------------
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.
--------------------------------------------------------
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
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
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: https://www.postgresql.org/message-id/20180429222104.GA25267%40fetter.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.c om> 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