Re: Group Commits Vs WAL Writes - Mailing list pgsql-hackers

From Atri Sharma
Subject Re: Group Commits Vs WAL Writes
Date
Msg-id CAOeZVidycMg891PwyKDEo_+8SEQwct_guCPzFCBA7AKh_NgQ_A@mail.gmail.com
Whole thread Raw
In response to Re: Group Commits Vs WAL Writes  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Group Commits Vs WAL Writes
List pgsql-hackers
> Well, it does take longer to fsync a larger byte range to disk than a
> smaller byte range, in some cases.  But it's generally more efficient
> to write one larger range than many smaller ranges, so you come out
> ahead on the whole.

Right, that does make sense.

So, the overhead of writing a lot of WAL buffers is mitigated because
one large write is better than lots of smaller rights?

Regards,

Atri


--
Regards,

Atri
l'apprenant



pgsql-hackers by date:

Previous
From: Atri Sharma
Date:
Subject: Re: Group Commits Vs WAL Writes
Next
From: Andres Freund
Date:
Subject: Re: extensible external toast tuple support