Re: [HACKERS] wal buffers documentation -errata

2007-01-11 Thread Dave Cramer
On 11-Jan-07, at 12:49 PM, Tom Lane wrote: Dave Cramer <[EMAIL PROTECTED]> writes: the point is that the documentation suggests that the default is 8 not 8MB, but 8, when in fact the defaults are now given in memory units not pages Oh, I thought you were complaining that the value was numeri

Re: [HACKERS] wal buffers documentation -errata

2007-01-11 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > the point is that the documentation suggests that the default is 8 > not 8MB, but 8, when in fact the defaults are now given in memory > units not pages Oh, I thought you were complaining that the value was numerically wrong. Perhaps we should convert t

Re: [HACKERS] wal buffers documentation -errata

2007-01-11 Thread Dave Cramer
Tom, the point is that the documentation suggests that the default is 8 not 8MB, but 8, when in fact the defaults are now given in memory units not pages Dave On 11-Jan-07, at 10:09 AM, Tom Lane wrote: Dave Cramer <[EMAIL PROTECTED]> writes: However I just loaded up an 8.2.1 and the defau

Re: [HACKERS] wal buffers documentation -errata

2007-01-11 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > However I just loaded up an 8.2.1 and the default is 32m Then you changed it in postgresql.conf. I get $ psql Welcome to psql 8.2.1, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands

[HACKERS] wal buffers documentation -errata

2007-01-11 Thread Dave Cramer
Currently says Number of disk-page buffers allocated in shared memory for WAL data. The default is 8. The setting need only be large enough to hold the amount of WAL data generated by one typical transaction, since the data is written out to disk at every transaction commit. This paramete