Sample Header Ad - 728x90

About "wal_buffers" of Postgresql-11 with "synchronous_commit=off"

0 votes
2 answers
163 views
Last days I tuned my PG11 for a lots of huge writing transactions, and got a amazing result. The only warry in my mind is that whether there is more risk of lossing data when I turned off synchronous_commit, and used a large wal_buffers value.
Asked by Leon (411 rep)
Feb 11, 2023, 02:12 AM
Last activity: Feb 14, 2023, 02:58 AM