fsync data directory after DB crash

[Pandora]

I found that starting from version 9.5, PostgreSQL will do fsync on the entire 
data directory after DB crash. Here's a question: if I have FPW = on, why is 
this step still necessary?

?????? fsync data directory after DB crash

[Pandora]

Yes, I saw the usage of syncfs in PG14, but it is recommended to use it on 
Linux 5.8 or higher. If my OS version is lower than 5.8, can I still enable it?


 


Pandora
yeyu...@qq.com



 




--  --
??: "Thomas Munro"https://www.postgresql.org/message-id/flat/CA%2BhUKGKgj%2BSN6z91nVmOmTv2KYrG7VnAGdTkWdSjbOPghdtooQ%40mail.gmail.com#576caccf21cb6c3e883601fceb28d36b

Only recovery_init_sync_method=syncfs actually went in from that
thread.  It works better for some setups (systems where opening
squillions of files just do perform a no-op fsync() is painfully
expensive).

whether I can add a new encoding?

[Pandora]

The pg_wchar.h file comments "We must avoid renumbering any backend encoding 
until libpq's major version number is increased beyond 5", Can I add a new 
server-side encoding, GBK18030, and place it after PG_KOI8U in PG10.6?