Re: Postgresql TPS Bottleneck - Mailing list pgsql-performance

From MichaelDBA
Subject Re: Postgresql TPS Bottleneck
Date
Msg-id 97bb1892-4f54-9410-77bc-f8cd93f779a3@sqlexec.com
Whole thread Raw
In response to Postgresql TPS Bottleneck  (<wakandavision@outlook.com>)
List pgsql-performance
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


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




pgsql-performance by date:

Previous
From: Mladen Gogala
Date:
Subject: Re: HIGH IO and Less CPU utilization
Next
From: Tomas Vondra
Date:
Subject: Re: Postgresql TPS Bottleneck