fsync data directory after DB crash

2023-07-18 Thread 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

2023-07-19 Thread 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.o

whether I can add a new encoding?

2023-09-21 Thread 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?