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 1ow75Y-0000Lc-1L for pgsql-hackers@arkaria.postgresql.org; Fri, 18 Nov 2022 19:31:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ow75W-0006Xn-RQ for pgsql-hackers@arkaria.postgresql.org; Fri, 18 Nov 2022 19:31:46 +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 1ow75W-0006Xd-Hr for pgsql-hackers@lists.postgresql.org; Fri, 18 Nov 2022 19:31:46 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ow75U-0005LV-3R for pgsql-hackers@postgresql.org; Fri, 18 Nov 2022 19:31:45 +0000 Received: from bruce by momjian.us with local (Exim 4.94.2) (envelope-from ) id 1ow75O-006OgP-TJ; Fri, 18 Nov 2022 14:31:38 -0500 Date: Fri, 18 Nov 2022 14:31:38 -0500 From: Bruce Momjian To: Laurenz Albe Cc: Robert Treat , Simon Riggs , Alvaro Herrera , Erik Rijkers , Justin Pryzby , PostgreSQL Hackers Subject: Re: New docs chapter on Transaction Management and related changes Message-ID: References: <20221014084615.chvollxv3oz43oqu@alvherre.pgsql> <80a5fd9c080d66e62f90c9565e3e1b54e61f584c.camel@cybertec.at> <3603e6e85544daa5300c7106c31bc52673711cd0.camel@cybertec.at> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Nov 10, 2022 at 08:39:29AM +0100, Laurenz Albe wrote: > > > I don't think that is an improvement.  "Unaborted" is an un-word.  A new transaction > > > is always "unaborted", isn't it? > > > > I thought about this as well when reviewing it, but I do think > > something is needed for the case where you have a transaction which > > has suffered an error and then you issue "rollback and chain"; if you > > just say "a new transaction is immediately started with the same > > transaction characteristics" it might imply to some the new > > transaction has some kind of carry over of the previous broken > > transaction... the use of the word unaborted makes it clear that the > > new transaction is 100% functional. > > A new transaction is never aborted in my understanding. Being aborted is not a > characteristic of a transaction, but a state. I used "(unaborted)", which seems to be a compromise. > > > > +    The internal transaction ID type xid is 32-bits wide > > > > > > There should be no hyphen in "32 bits wide", just as in "3 years old". > > > > Minor aside, we should clean up glossary.sgml as well. > > Right, it has this: > > The numerical, unique, sequentially-assigned identifier that each > transaction receives when it first causes a database modification. > Frequently abbreviated as xid. > When stored on disk, xids are only 32-bits wide, so only > approximately four billion write transaction IDs can be generated; > to permit the system to run for longer than that, > epochs are used, also 32 bits wide. > > Which reminds me that I should have suggested rather than > where I complained about the use of . I changed them to "firstterm". -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Indecision is a decision. Inaction is an action. Mark Batterson