Re: Decoding speculative insert with toast leaks memory

From: Dilip Kumar <dilipbalaut(at)gmail(dot)com>
To: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
Cc: Andres Freund <andres(at)anarazel(dot)de>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Petr Jelinek <petr(dot)jelinek(at)enterprisedb(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com>
Subject: Re: Decoding speculative insert with toast leaks memory
Date: 2021-06-09 10:42:34
Message-ID: CAFiTN-vB--Q4Eg=gotpjVT=7fAbG8ZrbA=pjbwTUiXzKntA6ug@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jun 9, 2021 at 11:03 AM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:

> On Tue, Jun 8, 2021 at 5:16 PM Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
> >
> > Based on the off list discussion, I have modified the test based on
> > the idea showed in
> > "isolation/specs/insert-conflict-specconflict.spec", other open point
> > we had about the race condition that how to ensure that when we unlock
> > any session it make progress, IMHO the isolation tested is designed in
> > a way that either all the waiting session returns with the output or
> > again block on a heavy weight lock before performing the next step.
> >
>
> Few comments:
> 1. The test has a lot of similarities and test duplication with what
> we are doing in insert-conflict-specconflict.spec. Can we move it to
> insert-conflict-specconflict.spec? I understand that having it in
> test_decoding has the advantage that we can have all decoding tests in
> one place but OTOH, we can avoid a lot of test-code duplication if we
> add it in insert-conflict-specconflict.spec.
>
>
It seems the isolation test runs on the default configuration, will it be a
good idea to change the wal_level to logical for the whole isolation tester
folder?

--
Regards,
Dilip Kumar
EnterpriseDB: http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ajin Cherian 2021-06-09 10:46:13 Re: Decoding of two-phase xacts missing from CREATE_REPLICATION_SLOT command
Previous Message Tomas Vondra 2021-06-09 10:30:17 Re: postgres_fdw batching vs. (re)creating the tuple slots