Home > mailing lists

bgwriter_flush_after - Mailing list pgsql-admin

From	Henry Francisco Garcia Cortez
Subject	bgwriter_flush_after
Date	October 15, 2021 00:34:57
Msg-id	CAJP2v3GgH37yQ72S+Aa_9TAk9_+27bMF30aM-vW+PCL4kmqB=g@mail.gmail.com Whole thread Raw
Responses	Re: bgwriter_flush_after ("David G. Johnston" <david.g.johnston@gmail.com>)
List	pgsql-admin

I was reading about bgwriter_flush_after I found this website https://postgreshelp.com/postgresql_shared_buffers/ however, I have some questions:

First the parameter bgwriter_flush_after is amount of pages that operating system’s cache could download to disk every time Fsync is called.

Second If I want to increase the parameter bgwriter_flush_after, for instance to 2MB Will I get a better performance? and

Finally, What will be the cons of increasing this parameter?

Ing. Henry G. Cortez

From: Satoshi Nakamoto
Date: 12 October 2021, 23:22:40
Subject: Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE

From: "David G. Johnston"
Date: 15 October 2021, 00:53:48
Subject: Re: bgwriter_flush_after