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
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
Hi!
Here is the case.
Assume we have a master to slave replication with shared_buffers set up
to 2 GB at the master and 4 GB at the slave. All of the data is written
to the master, while reading occurs from slave.
Now we decided to drop many tables, let's say 1000 or 1 not in a
single t
