Re: Postgresql TPS Bottleneck

[MichaelDBA]

While setting these 2 parameters to off will make things go faster 
(especially for fsync), it is unrealistic to have these settings in a 
production environment, especiall fsync=off.  You might get by with 
synchronous_commit=off, but with fsync=off you could end up with 
corruption in your database.  synchronous_commit may not make anything 
go faster just change where the time is being spent.

Regards,
Michael Vitale

wakandavis...@outlook.com wrote on 3/31/2022 7:50 AM:
fsync = off
synchronous_commit = off