Horton

Re: 回复：Re: Cache relation sizes?

David Steele <david@pgmasters.net>

View thread View on postgr.es
From: David Steele <david@pgmasters.net>
To: Thomas Munro <thomas.munro@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>, Konstantin Knizhnik <k.knizhnik@postgrespro.ru>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, 陈佳昕(步真) <buzhen.cjx@alibaba-inc.com>
Date: 2021-03-03T13:39:54Z
Lists: pgsql-hackers 
Hi Thomas,

On 1/18/21 10:42 PM, 陈佳昕(步真) wrote:
> I want to share a patch with you, I change the replacement algorithm 
> from fifo to a simple lru.

What do you think of this change?

Also, your patch set from [1] no longer applies (and of course this 
latest patch is confusing the tester as well).

Marking Waiting on Author.

Regards,
-- 
-David
david@pgmasters.net

[1] 
https://www.postgresql.org/message-id/CA%2BhUKGLQU%3DtxW6maxZJoU3v-a42i%3D_UN2YLeB%2BaW6JuKcYrUBA%40mail.gmail.com

Commits

  1. Optimize DropRelFileNodesAllBuffers() for recovery.

  2. Cache smgrnblocks() results in recovery.

  3. Use pg_pread() and pg_pwrite() for data files and WAL.

  4. Add a check to prevent overwriting valid data if smgrnblocks() gives a