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
Last activity: Feb 14, 2023, 02:58 AM