Re: Potential Large Performance Gain in WAL synching - Mailing list pgsql-hackers

From Zeugswetter Andreas SB SD
Subject Re: Potential Large Performance Gain in WAL synching
Date
Msg-id 46C15C39FEB2C44BA555E356FBCD6FA4961EB1@m0114.s-mxs.net
Whole thread Raw
In response to Potential Large Performance Gain in WAL synching  ("Curtis Faith" <curtis@galtair.com>)
List pgsql-hackers
> Hmmm ... if you were willing to dedicate a half meg or meg of shared
> memory for WAL buffers, that's doable.

Yup, configuring Informix to three 2 Mb buffers (LOGBUF 2048) here.

> However, this would only be a win if you had few and large transactions.
> Any COMMIT will force a write of whatever we have so far, so the idea of
> writing hundreds of K per WAL write can only work if it's hundreds of K
> between commit records.  Is that a common scenario?  I doubt it.

It should help most for data loading, or mass updating, yes.

Andreas


pgsql-hackers by date:

Previous
From: "Michael Paesold"
Date:
Subject: Re: Improving backend startup interlock
Next
From: Greg Copeland
Date:
Subject: Re: Potential Large Performance Gain in WAL synching