Thanks Laurenz, will try these flags.
Regards,
Subhrajyoti
On Fri, Oct 1, 2021 at 5:19 PM Laurenz Albe
wrote:
> On Fri, 2021-10-01 at 14:22 +0530, Subhrajyoti Senapati wrote:
> > Was running a few sysbench tests in Postgres12.
> > Sysbench Test Config
> > oltp-readwrite-custom
> > Threads - 500
On Fri, 2021-10-01 at 14:22 +0530, Subhrajyoti Senapati wrote:
> Was running a few sysbench tests in Postgres12.
> Sysbench Test Config
> oltp-readwrite-custom
> Threads - 500
> Machine: 16 core 64G
>
> In PG server:
> shared_buffers: 16GB
> maintenance_work_memory: 16GB
> checkpoint_timeout: 1h
>