Sample Header Ad - 728x90

Should i enable synchronous_commit option on single node master database server?

0 votes
1 answer
49 views
I have an EnterpriseDB 11 database server and not clustered. It's a single master database server with no replica. I see an option named synchronous_commit option on the postgres.conf file. It has **synchronous_commit=remote_apply** and on running huge queries it is causing performance degradation. **So should i hash it ?**
Asked by MD Nasirul Islam (101 rep)
Sep 2, 2023, 06:30 AM
Last activity: Oct 28, 2023, 06:47 PM