Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pooJH-0004sy-7g for pgsql-general@arkaria.postgresql.org; Tue, 18 Apr 2023 16:36:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pooJG-0005c6-0f for pgsql-general@arkaria.postgresql.org; Tue, 18 Apr 2023 16:36:02 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pooJF-0005bv-L4 for pgsql-general@lists.postgresql.org; Tue, 18 Apr 2023 16:36:01 +0000 Received: from sss.pgh.pa.us ([66.207.139.130]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pooJA-000Wvs-Lb for pgsql-general@lists.postgresql.org; Tue, 18 Apr 2023 16:35:58 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 33IGZqG92664329; Tue, 18 Apr 2023 12:35:53 -0400 From: Tom Lane To: Laurenz Albe cc: gayathri ramesh <17gayathriramesh@gmail.com>, pgsql-general@lists.postgresql.org Subject: Re: Request for information about postgres version 15.2 stability In-reply-to: <5100adfe28807f9278ee796c52181f2a4cc71b3d.camel@cybertec.at> References: <5100adfe28807f9278ee796c52181f2a4cc71b3d.camel@cybertec.at> Comments: In-reply-to Laurenz Albe message dated "Tue, 18 Apr 2023 18:04:35 +0200" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <2664327.1681835752.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Tue, 18 Apr 2023 12:35:52 -0400 Message-ID: <2664328.1681835752@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Laurenz Albe writes: > We don't have any information about yet undiscovered PostgreSQL bugs. Indeed. > We believe that PostgreSQL 15.2 is a great and stable database, but we a= re biased. One moderately objective way to see how stable a release branch is is to count how many commits fix bugs in that branch but not any older branch. If a bug would be problematic for you but it also appears in (say) v14 and v13, then choosing to use one of those branches instead of v15 wouldn't have saved you. Also, if a commit goes back that far, it means that the bug escaped detection for multiple years in production, which suggests that it is minor and/or doesn't affect many people. (I hasten to add that we do find some bugs that are both old and serious.) A quick review of commits since 15.2 says that practically all of the ones that don't also affect v14 or before have to do with glitches in new-in-15 features, such as the MERGE command. Which is code you wouldn't be using anyway if your application would be satisfied with an older branch. So I'd judge that 15 is pretty stable at this point, and there is very little reason to prefer any older branch. If you want to do your own analysis along these lines, the gitweb interface isn't especially friendly for comparing commit logs of different branches. I'd suggest using our git_changelog script: git clone https://git.postgresql.org/git/postgresql.git cd postgresql src/tools/git_changelog >../pg-revision-history This produces output that collates matching commits in different branches. regards, tom lane