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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1pyuyK-00066O-35
	for pgsql-admin@arkaria.postgresql.org; Tue, 16 May 2023 13:44:12 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1pyuyI-0000lU-RP
	for pgsql-admin@arkaria.postgresql.org; Tue, 16 May 2023 13:44:10 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1pyuyI-0000lJ-FE
	for pgsql-admin@lists.postgresql.org; Tue, 16 May 2023 13:44:10 +0000
Received: from mail-yb1-xb2b.google.com ([2607:f8b0:4864:20::b2b])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <ronljohnsonjr@gmail.com>)
	id 1pyuyA-0009Ar-OY
	for pgsql-admin@lists.postgresql.org; Tue, 16 May 2023 13:44:09 +0000
Received: by mail-yb1-xb2b.google.com with SMTP id
 3f1490d57ef6-ba8151a744fso1467140276.2
        for <pgsql-admin@lists.postgresql.org>;
 Tue, 16 May 2023 06:44:03 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20221208; t=1684244641; x=1686836641;
        h=in-reply-to:from:references:to:content-language:subject:user-agent
         :mime-version:date:message-id:from:to:cc:subject:date:message-id
         :reply-to;
        bh=ZBkUmdku6rZJaxi8xu2GyDC6RNRAH7vGlP3piEqhthg=;
        b=hvqCg/dm1emFGmRjJ3WsuFcAFGqyrOsgK1gj4eSa8pB9rlFmtQEsjUDNzebauuXXH0
         djBfFkdKO5bQ7737OoKi37m3lQwnM/RadZwTJDghwZ1D6uhrgEGjqmbAKmz2aLQDVebC
         MogORDbx0ckr0DIqox9NidWDC4DzIe44R7lTNxZeMdySbMLXWO2Ntdcsq5ndTBkpcBy2
         5mDjBw5Nyk5cReW5BzWsrBYVq/Qs8/c2WtepojINYoQqqtGPBjlv2SJb1TfNbiEs/g6D
         2zQnbWsTKKZZwWTqX4gtmYyOCfxXaAIMfLmLeV3MhNtrAtAdEzF7XrRSgVa6ZT+DNjE6
         RzPg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20221208; t=1684244641; x=1686836641;
        h=in-reply-to:from:references:to:content-language:subject:user-agent
         :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject
         :date:message-id:reply-to;
        bh=ZBkUmdku6rZJaxi8xu2GyDC6RNRAH7vGlP3piEqhthg=;
        b=YYuaJ4TiQ5m/9G8CFYmOVPm7nunf79exWHY2a4OGqX/LS759G40q0cuB0rYrdE4wM1
         pYK6D5+84B8kEnHVcKk4hMpJsCCqVDGR1Ocul+d7WrMiWX2lD8moxIccKPOI3pouQdx+
         UmnGVQa7gMhYp+evujJI86GYoVpaf4WOCSfvTiPxI5WMiVzkJbk4yuXJMSo0fjv71tR8
         SqJnjVKT5o6vnNY5P0iwjxWLjzyQ3W4uCaWk6UMUyBrJAEVc5slfghYjWy59oAxatK/c
         YYKlKaOpM6r8aHfBaYJ4gq6gQh3Gv4NKVUWVeqW8y9QqOXYqK+J8SzCi0/RzSW4h8vmG
         JO6Q==
X-Gm-Message-State: AC+VfDwMPhLv5ZHw7l3/e5qCthxH0CIH3yHXAj+9BYjoHnemNeErlOwp
	8EQBaNOLkPHFMzzOk//vMqccmwg/pcg=
X-Google-Smtp-Source: 
 ACHHUZ4C13lP/jSGlqAJ/B55SL8FxG83DmXq1ohzXV93bYZLjn26XUZ2zhE0+dTjdWDWVeQ1BDoWCQ==
X-Received: by 2002:a25:c787:0:b0:ba7:94e4:c78f with SMTP id
 w129-20020a25c787000000b00ba794e4c78fmr7589517ybe.20.1684244641092;
        Tue, 16 May 2023 06:44:01 -0700 (PDT)
Received: from ?IPV6:2600:1700:bd2c:b810:cc23:f234:2e34:bf3f?
 ([2600:1700:bd2c:b810:cc23:f234:2e34:bf3f])
        by smtp.googlemail.com with ESMTPSA id
 b4-20020a25ae84000000b00ba755f271c1sm499021ybj.9.2023.05.16.06.44.00
        for <pgsql-admin@lists.postgresql.org>
        (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128);
        Tue, 16 May 2023 06:44:00 -0700 (PDT)
Content-Type: multipart/alternative;
 boundary="------------0iPW4atAvU9WNGcwc1P7cIT8"
Message-ID: <0ff97f0c-cc86-8544-0c4d-82900528c69c@gmail.com>
Date: Tue, 16 May 2023 08:44:00 -0500
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.10.0
Subject: Re: ERROR: could not serialize access due to concurrent update
Content-Language: en-US
To: pgsql-admin@lists.postgresql.org
References: 
 <CAKDb7aFR1B7wvaLBxBDdark7jx=y31BY74WKdrPF1Zq5xwT+mA@mail.gmail.com>
 <CAKDb7aHL=NXzcFyL5oM3V6=D9P4VVdx_Gd=FskdbeqCotKFSSg@mail.gmail.com>
From: Ron <ronljohnsonjr@gmail.com>
In-Reply-To: 
 <CAKDb7aHL=NXzcFyL5oM3V6=D9P4VVdx_Gd=FskdbeqCotKFSSg@mail.gmail.com>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/0ff97f0c-cc86-8544-0c4d-82900528c69c%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------0iPW4atAvU9WNGcwc1P7cIT8
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Scan, you say?  Add an index to support the FK lookup.

On 5/16/23 08:09, ROHIT SACHDEVA wrote:
> Also foreign table scan is there on query.
>
> On Tue, May 16, 2023 at 6:08 PM ROHIT SACHDEVA 
> <sachdeva.rohit648@gmail.com> wrote:
>
>      Hi All,
>     I am getting this error in the application logs, and this error is
>     frequently coming. Could someone suggest what would be the best
>     solution to overcome these types of errors.
>     Isolation of the database is read committed. Should I change the
>     isolation?
>
>
>     -- 
>     Have a Good day !!!
>
>     Regards
>     Rohit Sachdeva
>
>
>
> -- 
> Have a Good day !!!
>
> Regards
> Rohit Sachdeva

-- 
Born in Arizona, moved to Babylonia.
--------------0iPW4atAvU9WNGcwc1P7cIT8
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    Scan, you say?  Add an index to support the FK lookup.<br>
    <br>
    <div class="moz-cite-prefix">On 5/16/23 08:09, ROHIT SACHDEVA wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAKDb7aHL=NXzcFyL5oM3V6=D9P4VVdx_Gd=FskdbeqCotKFSSg@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">Also foreign table scan is there on query.</div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">On Tue, May 16, 2023 at
          6:08 PM ROHIT SACHDEVA &lt;<a
            href="mailto:sachdeva.rohit648@gmail.com"
            moz-do-not-send="true" class="moz-txt-link-freetext">sachdeva.rohit648@gmail.com</a>&gt;
          wrote:<br>
        </div>
        <blockquote class="gmail_quote" style="margin:0px 0px 0px
          0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
          <div dir="ltr"> Hi All,<br style="color:rgb(37,37,37)">
            I am getting this error in the application logs, and this
            error is frequently coming. Could someone suggest what would
            be the best solution to overcome these types of errors.<br
              style="color:rgb(37,37,37)">
            Isolation of the database is read committed. Should I change
            the isolation?  <br>
            <div><br clear="all">
              <div><br>
              </div>
              <span>-- </span><br>
              <div dir="ltr">Have a Good day !!!<br>
                <br>
                Regards<br>
                Rohit Sachdeva</div>
            </div>
          </div>
        </blockquote>
      </div>
      <br clear="all">
      <div><br>
      </div>
      <span class="gmail_signature_prefix">-- </span><br>
      <div dir="ltr" class="gmail_signature">Have a Good day !!!<br>
        <br>
        Regards<br>
        Rohit Sachdeva</div>
    </blockquote>
    <br>
    <div class="moz-signature">-- <br>
      Born in Arizona, moved to Babylonia.</div>
  </body>
</html>

--------------0iPW4atAvU9WNGcwc1P7cIT8--