Re: [PATCH] lazy relations delete

2020-01-07 Thread Thomas Munro
On Wed, Jan 8, 2020 at 5:20 PM Kyotaro Horiguchi wrote: > Relfilenode can be reused right after commit. There can be a case > where readers of the resued relfilenode see the pages from already > removed files left on shared buffers. On the other hand newly > allocated buffers for the reused relfil

Re: [PATCH] lazy relations delete

2020-01-07 Thread Kyotaro Horiguchi
Hello. At Tue, 31 Dec 2019 13:16:49 +0300, Maxim Orlov wrote in > Now we decided to drop many tables, let's say 1000 or 1 not in a > single transaction, but each table in a separate one. So, due to > "plain" shared_buffers memory we have to do for loop for every > relation which leads to la