Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTjzH-001wS7-6o for pgsql-docs@arkaria.postgresql.org; Tue, 16 Jul 2024 15:21:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sTjzE-001h06-78 for pgsql-docs@arkaria.postgresql.org; Tue, 16 Jul 2024 15:21:04 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sTjzD-001gzy-Qf for pgsql-docs@lists.postgresql.org; Tue, 16 Jul 2024 15:21:03 +0000 Received: from mail-ej1-x62a.google.com ([2a00:1450:4864:20::62a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sTjzA-002MJJ-2i for pgsql-docs@lists.postgresql.org; Tue, 16 Jul 2024 15:21:02 +0000 Received: by mail-ej1-x62a.google.com with SMTP id a640c23a62f3a-a77e392f59fso674028766b.1 for ; Tue, 16 Jul 2024 08:20:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1721143258; x=1721748058; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=e58vQ3PttbneWpeREVWV8TtNuirq4ISi0xuxPGlDF6I=; b=d9dmKK/4t9xRBZ415/+XMKg8QPe0VKZjGt2jzufxTJ6cfcPcpdcJ8VWGxOlmSFKTc1 FmvxQGEtkDPDvfP26bYLM2dVxLZIE+93y+DpYJVO7tnlnpHSKczU7MgPC0lUqB9PQIQb 17dOQvWCIU8TGyy026KODciS6CgFwhHdQ1ZTWl+fIT7La8VL6uG2oDHyVQ+EBaJwh1Fi lLmZxGkXTlxj1nksm1dBGtIGruKUMOaRkHmpGO5Nzg/M70ytNBilabDa9FNjtos7yXRx c/7logq5366cqkJ8x601sliTfiQNf1vdmdAjP6YB+mPKvr8/Ei9s5Zh+h+ZizVu/oN3n 08hQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1721143258; x=1721748058; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=e58vQ3PttbneWpeREVWV8TtNuirq4ISi0xuxPGlDF6I=; b=roTq94aJinSZ4V6PfBFcdD2TuH6b5JMGPIQfb6jliX4/YxDooArWOSfGsbeANbBUBc TdG7epHoixnpooQSQTl4TiyjUXrSuTOt2ZqKXlRu/73ylpK9MIz8HtzM8zGsS3YzbGNQ IFdw4dqt7/D9zZrVdBqv1+i12lE4+NTeal+PrQFi3cTpjsukiDV+/DrQADqulmf5hxvX ExEM9+XSuh2ApIuaX/Vr6sY4hnXHvGjcfhK86jHb812U7TAlCG9/JtjosyS7g3ulD6Wv z6EvvjlSwAc7CHsgWDi2ndnj1bYdxDYVA1zJ+7m4OQzY1hFjWSb8zuTl8Pm4ARPifkB/ JrPQ== X-Forwarded-Encrypted: i=1; AJvYcCVTVJKFgkSbgAszPscJZuOKqE5xmMgPbyVWFTDfbW5CxrL/+W8APki9gkL5ev5jHLX03nhHrF+fcwVs+Ki0831vBM5ZMbLnLZoMvPZ0/g2g X-Gm-Message-State: AOJu0YwqITui+6E6rry+LLELB/MO8dLQraXUJDNBrSfjdIWt0RJ8I1wk wvFX0TrGBgmsmteuHmMYmuDmaOF5remydEuTmQ88H88CQ63MgFD46iWUHDBIeBrgMUSIcD7QgbH U X-Google-Smtp-Source: AGHT+IEyPgvNzdN0T1lFwC9TqEjAzdIjcMDA1w2MWn4yesyzMGunY1cvV270I5PhH11veIKkJazIkg== X-Received: by 2002:a17:906:555:b0:a77:b54f:c25e with SMTP id a640c23a62f3a-a79eaa3f34amr146128266b.53.1721143258158; Tue, 16 Jul 2024 08:20:58 -0700 (PDT) Received: from localhost.localdomain ([2001:871:260:9f4c:1089:7676:8d34:6d2a]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a79bc5a390dsm327296866b.41.2024.07.16.08.20.57 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 16 Jul 2024 08:20:57 -0700 (PDT) Message-ID: Subject: Re: 13.2.1. Read Committed Isolation Level From: Laurenz Albe To: lebedewwasya@gmail.com, pgsql-docs@lists.postgresql.org Date: Tue, 16 Jul 2024 17:20:56 +0200 In-Reply-To: <172093785742.736591.6600074945096543093@wrigleys.postgresql.org> References: <172093785742.736591.6600074945096543093@wrigleys.postgresql.org> Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2024-07-14 at 06:17 +0000, PG Doc comments form wrote: > Page: https://www.postgresql.org/docs/16/transaction-iso.html > Description: >=20 > I don't understend this text. >=20 > [five paragraphs from the documentation] > > Could you please describe this behavior in more detail? It is difficult to help you if you are that unspecific about what exactly you fail to understand. Sure, there are some complicated concepts involved= . If you can't understand *anything* about that text, perhaps you should start reading the whole chapter about concurrency. Yours, Laurenz Albe