Message-ID: <e54a6cfe-59fe-831d-55e9-3d5fa037894a@ardentperf.com>
Date: Tue, 12 Oct 2021 15:55:53 -0700
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:91.0)
 Gecko/20100101 Thunderbird/91.1.2
Subject: Re: [BUG] Logical replication failure "ERROR: could not map filenode
 "base/13237/442428" to relation OID" with catalog modifying txns
Content-Language: en-US
To: Masahiko Sawada <sawada.mshk@gmail.com>,
 Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: "Drouvot, Bertrand" <bdrouvot@amazon.com>,
 PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
 "Oh, Mike" <minsoo@amazon.com>
References: 
 <CAD21AoCxVNYK0R=SSPchcx1wm6mx=qJ5W8qDVakFCOAy1UxqAQ@mail.gmail.com>
 <6a176936-1af1-41d9-9ded-bde0eb47dd5c@amazon.com>
 <CAD21AoAn-k6OpZ6HSAH_G91tpTXR6KYvkf663kg6EqW-f6sz1w@mail.gmail.com>
 <20211008.165055.1621145185927268721.horikyota.ntt@gmail.com>
 <CAD21AoD00wV4gt-53ze+ZB8n4bqJrdH8J_UnDHddy8S2A+a25g@mail.gmail.com>
From: Jeremy Schneider <schneider@ardentperf.com>
In-Reply-To: 
 <CAD21AoD00wV4gt-53ze+ZB8n4bqJrdH8J_UnDHddy8S2A+a25g@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/e54a6cfe-59fe-831d-55e9-3d5fa037894a%40ardentperf.com>
Precedence: bulk

On 10/10/21 23:27, Masahiko Sawada wrote:
> 
> After more thought, given DDLs are not likely to happen than DML in
> practice, ...

I haven't looked closely at the patch, but I'd be careful about
workloads where people create and drop "temporary tables". I've seen
this pattern used a few times, especially by developers who came from a
SQL server background, for some reason.

I certainly don't think we need to optimize for this workload - which is
not a best practice on PostreSQL. I'd just want to be careful not to
make PostgreSQL logical replication crumble underneath it, if PG was
previously keeping up with difficulty. That would be a sad upgrade
experience!

-Jeremy

-- 
http://about.me/jeremy_schneider