| From: | Henry Francisco Garcia Cortez <garcortez(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Cc: | aurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, alvherre(at)2ndquadrant(dot)com, David(dot)G(dot)Johnston(at)gmail(dot)com |
| Subject: | bgwriter_flush_after |
| Date: | 2021-10-14 21:34:57 |
| Message-ID: | CAJP2v3GgH37yQ72S+Aa_9TAk9_+27bMF30aM-vW+PCL4kmqB=g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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 | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2021-10-14 21:53:48 | Re: bgwriter_flush_after |
| Previous Message | Satoshi Nakamoto | 2021-10-12 20:22:40 | Re: Recover Disk Space From Terminated VACUUM FULL ANALYZE |