Ian, Thomas,
> Thanks; I'd seen the documentation, but not Josh Berkus'
> testing.
BTW, that's still an open question for me. I'm now theorizing that it's
best to set wal_buffers to the expected maximum number of concurrent write
connections. However, I don't have enough test systems to test
On Thu, Oct 06, 2005 at 08:56:31AM -0400, Ian Westmacott wrote:
> On Thu, 2005-10-06 at 02:39, Thomas F. O'Connell wrote:
> > The WAL Configuration chapter (25.2) has a pretty good discussion of
> > how wal_buffers is used:
> >
> > http://www.postgresql.org/docs/8.0/static/wal-configuration.html
On Thu, 2005-10-06 at 02:39, Thomas F. O'Connell wrote:
> The WAL Configuration chapter (25.2) has a pretty good discussion of
> how wal_buffers is used:
>
> http://www.postgresql.org/docs/8.0/static/wal-configuration.html
>
> You might also take a look at Josh Berkus' recent testing on this
On Oct 5, 2005, at 8:23 AM, Ian Westmacott wrote:
Can anyone tell me what precisely a WAL buffer contains,
so that I can compute an appropriate setting for
wal_buffers (in 8.0.3)?
I know the documentation suggests there is little
evidence that supports increasing wal_buffers, but we
are insert
Can anyone tell me what precisely a WAL buffer contains,
so that I can compute an appropriate setting for
wal_buffers (in 8.0.3)?
I know the documentation suggests there is little
evidence that supports increasing wal_buffers, but we
are inserting a large amount of data that, I believe,
easily exc
