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.96) (envelope-from ) id 1wk3qY-000RhF-1i for pgsql-general@arkaria.postgresql.org; Wed, 15 Jul 2026 17:56:38 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wk3qX-008jGV-1P for pgsql-general@arkaria.postgresql.org; Wed, 15 Jul 2026 17:56:37 +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.96) (envelope-from ) id 1wk3qW-008jGN-1j for pgsql-general@lists.postgresql.org; Wed, 15 Jul 2026 17:56:37 +0000 Received: from fhigh-b1-smtp.messagingengine.com ([202.12.124.152]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wk3qT-00000000MaA-3ypO for pgsql-general@lists.postgresql.org; Wed, 15 Jul 2026 17:56:35 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfhigh.stl.internal (Postfix) with ESMTP id 3DEBA7A0085; Wed, 15 Jul 2026 13:56:33 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-04.internal (MEProxy); Wed, 15 Jul 2026 13:56:33 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm1; t=1784138193; x=1784224593; bh=VxFVposMgJ/jZO41YlJHwogvN9Kn7hhi1f5SIYeVsro=; b= uG6mdcDaVuJGQj028ZM5lzKZXUjAtVJaJ2npSMdqWjm0yFdmqog6UDRsD9C9htdJ WeCMVtty5+SI/MD4XPfdkIMok2hEHG92b30HRJdcYEOXnDEX74+IsVGI3eOkKvCv fZRk1W8b73OQh89uOFVIRrMbFsbR9QmW27n2Dd1kstd6THXnPmTgA+kC9ESUN9J+ Wg+92TlJqRIATlfBpgFm70WVhEK6Crpjn6w3vj48nl9+Zn4NNBkw0C/uK+tXnWVO RG8FQEPbL2HQe+N53OGgZRdGP5Or5dXqSMKIaC2OOsi8pIHuXfXAv6LcXAUZyEoh y8pz+jKhJCFjCWG/pirOlg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1784138193; x=1784224593; bh=V xFVposMgJ/jZO41YlJHwogvN9Kn7hhi1f5SIYeVsro=; b=MwgaQ+Pf2YdHfKIQc EEdXFiQDHb4t1yZ6kAu+n2Y4GRPOzJYe+6Smfa3s7IBZi2RfCF+NS99bxjXEfbkB fCI0Aakw2A2MqjUceTdjmz0fQxM4nmgk0KSnDjbbesaMDSqBb+L1nUiv1wc/u9Gk oxzukYXKM+AMLDeFaoL6caHBFN7RtM6aH28dKv1HjO2PPuytxyXE03zQ/kGC7Zmx 6pntn1lGtF0BlTLCJ3XgX85WPD1SvD19XA/nGuyLjkez4GHhWk/jZamVAPSyC98h Z+UADFU3NkoHJlVs8daije+G3IcOtV7LgowVrPjW+MstW7USBev1PEwgRepN8kVc +7Wmw== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTGebctX87gsgSUNXIte75mg/bvLeMlEhDk+PD/Mrb7PFsxBPg8zqkLqCAzzPv8pML lgDrx2jLJ3jIwOQmnW2DOwNuuk4z3E56u4zGxCZXackBZWVeBIHj8uYK4yWQ97/9Pn4pv+ iB/Vh6qKCwkxhOG3vq2An03HqMqwuMLhLmqkKEaxlSwnBZBHnVKuJ/Q1wKjV2XXXeZRzqb TYExpwZOCynuFXlUYUE8YXXgkC2SMn6SaUxfshm4hKtl1jzDgo00JptcRnjaF/EdCZXfdJ 6mfah79b7lfLWS4RQeOEtmo0U3cvEvH7yqy+64TwZ9Xd0NGJiVJ+d+i2NCecmQzvuF0MId uDfxQOqJTvQw+C3NUYwk43utqc95FzU1LP18AtzgCP7NbjnyFnG5O/U1JGrxXrv61A7bJ+ lMteDClO5pIhmKneJOp+XVmbilQ9ru6DMmQEyuqVtvx9Fz19aPOGbDNya5gI6whPCI4D5e 7Itf7ujQL9DrNDLsHSOo6Ussub/RtoU2JqHWA54M8a0kv4vOp9Gp1sSpMid20Yyv44s9QP alvpd9CZMxqY+A/goeNvY4NLO3xfqSY7t1y7vezuqclTj+q0YA1GikH6NIIprqaCHTuNzO wSp/GGaeoLy/HKR2SjPZqNoCZVigKXjcn030gNYgE3tlunxGFlV8X5XX/1NQ X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 15 Jul 2026 13:56:32 -0400 (EDT) Message-ID: Date: Wed, 15 Jul 2026 10:56:31 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Transaction Isolation level for ERP software To: Mihir Kandoi , pgsql-general@lists.postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 7/15/26 10:34 AM, Mihir Kandoi wrote: > I work on an ERP software called ERPNext erpnext>. Currently, we use MariaDB with |REPEATABLE READ| . We have > been working on adding Postgres support to it but we have reached a > roadblock. > > Recently, we updated MariaDB on our cloud platform from 10.6 to 11.8. > After that, we received a barrage of support tickets from people > complaining of snapshot violation errors. Given the number of tickets > and the severity of an ERP software not functioning ideally, along with > constant nagging from enterprise customers, we temporarily disabled > snapshot isolation. This article: https://www.percona.com/blog/mariadbs-snapshot-isolation-a-fix-that-breaks-more-than-it-fixes/ seems to be a good explanation of what is actually happening, namely it is not actually a fix. > > Now with Postgres and |REPEATABLE READ| , there is no option like > MariaDB to just turn off snapshot violation errors. We believe that once > Postgres support hits production, we will again face another set of > similar serialization errors. Set up a Postgres test database and run your problematic queries against it and then you can go from 'believe' to know. -- Adrian Klaver adrian.klaver@aklaver.com