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 1tYPVj-00AeQ0-7Z for pgsql-general@arkaria.postgresql.org; Thu, 16 Jan 2025 13:02:11 +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 1tYPVh-00CVTP-M2 for pgsql-general@arkaria.postgresql.org; Thu, 16 Jan 2025 13:02:10 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tYPVh-00CVT0-Az for pgsql-general@lists.postgresql.org; Thu, 16 Jan 2025 13:02:09 +0000 Received: from mail-ed1-x52a.google.com ([2a00:1450:4864:20::52a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tYPVf-000lGZ-1S for pgsql-general@lists.postgresql.org; Thu, 16 Jan 2025 13:02:09 +0000 Received: by mail-ed1-x52a.google.com with SMTP id 4fb4d7f45d1cf-5d9f0a6adb4so1870952a12.1 for ; Thu, 16 Jan 2025 05:02:07 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1737032526; x=1737637326; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=doY6/gx4580u73/g/y+3p9qHsCrCukSQDo6xmoKA+fY=; b=aRJ54uvd+MTLi3+MlDNYg9fQhNOkJRsodSPTEstpZglx9c80gSFpxgulxWI2jthfHB wOgWfDupmn/4owvdEx0b+3INPcyyvmyVmwCeUE9Kd8J1OeLGPgGj/65IybvGzT/+Csiw HQUvMWtKgo3UuObeG5McKR2NGri4EQ5oi1fex+YEfoH15wE0gC3eN/Iy/Izq0ghBIte2 CbpxANYcSSe5zd8MaFSb7n9yo9FVL1yfaI+VwoLnB5DTFhQlDQWA7RQu0fNPNOpL2zXr YGkA/Etc+YFgMS7Q2K1mGVTEJdXixnbNuznNu0wPQao9vFLLf0DSLkhQrP3FoZi1oKRm jKLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737032526; x=1737637326; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=doY6/gx4580u73/g/y+3p9qHsCrCukSQDo6xmoKA+fY=; b=eiHrnEfq9CDOCT4MJPcEH4EdzHmU4N+w6EsEPwk24fvT2B265wBdz0tq/47ShCdNGs Hx2SQG3qhPHe6ug9rlXNX0zefwZM61C4rVgpEDh2x3swgqZGTYfk9INcoexxTDufkYem vSaWy/wIr84WfIRLAmALpisEjf8AJG288rs4OSQnYb4f9+zf5V9IZQxTBWFWLjeTdGSW +R0+Ix2ntZoz+Fk4cH63EryClNFX//Ln5USz90Vw59ifotZn2xeFIViCScMyOiOmZfeb IRyv/I61+j0zTwUyHO0YlTxrxsUIp5mG9bTI3JbO1sX7fsDUzMPVTTAClY55LLuaCn76 A+pA== X-Forwarded-Encrypted: i=1; AJvYcCWSG3r/U2yA/71Uj2VlCgqztTeW5WFn4YwoIuJUzsDaLYyP+8q9mzdhLUZ046PtUxjPUAEEUTKj+ZEDIuFU@lists.postgresql.org X-Gm-Message-State: AOJu0YxBW/zswaQIiyS0nvQbyZaLeO8w67yq3yoofjN+71FjvIg/4EFz oYsjp7qUFqTipwcpBb0B9xqciTS29AR4b8r13gpG1j2fjbUfRoEDjX+SXdGjyvw= X-Gm-Gg: ASbGncsYPIFy+m3c3rN4hwJh2LarImyxcopBhtGrWvy5UXNDD38fezJ4Sl3zKlCKCQ0 o36oVlDeR+BX66XqCFtbnDFkkoEHf8bB/DIaX3gMlo/bGxruux/oAERXK1sgo+nccgoiqarh7Pq xvGaNj4IlMErdD1iB27+mA+DCzJv2WKl0WvLffqIcKwVRRnEnFnzsoM2WTEfm1ngW53njtslU3s PXmIkkW1aec9kMnMSQWZEW/gAmu+Qrs0EYhVHy5ZjW7/h+xfTw7DRwUjPFXWCUakbrHPQaC0/LO X-Google-Smtp-Source: AGHT+IHUc6wIsIs6pM7zba4brK2IaFGTZDKCxA0SroyjraIbZ6cmkvqfmEQmwjhSePHzljUrhdYrIg== X-Received: by 2002:a05:6402:3581:b0:5d3:ba42:e9fe with SMTP id 4fb4d7f45d1cf-5d972e04bb3mr30908570a12.12.1737032525545; Thu, 16 Jan 2025 05:02:05 -0800 (PST) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-5d9904a4132sm8981104a12.75.2025.01.16.05.02.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 16 Jan 2025 05:02:05 -0800 (PST) Message-ID: Subject: Re: Is postgresql's json strong consistency or eventually consistency? From: Laurenz Albe To: anlex N , pgsql-general@lists.postgresql.org Date: Thu, 16 Jan 2025 14:02:04 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 2025-01-16 at 15:25 +0300, anlex N wrote: > I have searched all archives, but have no results. Please help me. That's probably because the question doesn't make much sense. A single PostgreSQL instance (=3Dcluster) enforces consistency, and it doesn't matter which data type you are using. So I guess the answer should be "strong consistency". Yours, Laurenz Albe