wal_sync_method
The documentation said in
http://www.postgresql.org/docs/8.3/static/wal-reliability.html in the
fourth paragraph (the one that talks about disk drive cache):
"""
On Windows if wal_sync_method is open_datasync (the default),
"""
But in my freshly 8.3.1 instalation on win xp, the default is
"fsync"... is a *bug* in the docs :)
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 087171157
"Jaime Casanova" <systemguards@gmail.com> writes:
But in my freshly 8.3.1 instalation on win xp, the default is
"fsync"... is a *bug* in the docs :)
More like a bug in the code. Does it let you set the value to
open_datasync?
regards, tom lane
On Sat, May 17, 2008 at 11:55 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Jaime Casanova" <systemguards@gmail.com> writes:
But in my freshly 8.3.1 instalation on win xp, the default is
"fsync"... is a *bug* in the docs :)More like a bug in the code. Does it let you set the value to
open_datasync?
yes it does...
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 087171157
[ redirecting to -bugs ]
"Jaime Casanova" <systemguards@gmail.com> writes:
On Sat, May 17, 2008 at 11:55 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Jaime Casanova" <systemguards@gmail.com> writes:
But in my freshly 8.3.1 instalation on win xp, the default is
"fsync"... is a *bug* in the docs :)More like a bug in the code. Does it let you set the value to
open_datasync?
yes it does...
Well, that's just bizarre. I found a problem in CVS HEAD that would
lead to a bogus selection of the default for wal_sync_method, but it
doesn't apply to 8.3. I really don't see how 8.3 would fail to use
open_datasync as the default if it's an available value. Did you
build 8.3.1 yourself, and if so how?
regards, tom lane
On Sat, May 17, 2008 at 1:45 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
[ redirecting to -bugs ]
"Jaime Casanova" <systemguards@gmail.com> writes:
On Sat, May 17, 2008 at 11:55 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
"Jaime Casanova" <systemguards@gmail.com> writes:
But in my freshly 8.3.1 instalation on win xp, the default is
"fsync"... is a *bug* in the docs :)More like a bug in the code. Does it let you set the value to
open_datasync?yes it does...
Well, that's just bizarre. I found a problem in CVS HEAD that would
lead to a bogus selection of the default for wal_sync_method, but it
doesn't apply to 8.3. I really don't see how 8.3 would fail to use
open_datasync as the default if it's an available value. Did you
build 8.3.1 yourself, and if so how?
nop, default installer downloaded from postgresql.org...
--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 087171157