Re: Postgresql TPS Bottleneck

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx wrote on 3/31/2022 7:50 AM:
fsync = off
synchronous_commit = off






[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux