public inbox for [email protected]help / color / mirror / Atom feed
wal_sync_method 5+ messages / 2 participants [nested] [flat]
* wal_sync_method @ 2008-05-17 05:10 Jaime Casanova <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Jaime Casanova @ 2008-05-17 05:10 UTC (permalink / raw) To: pgsql-docs 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: wal_sync_method @ 2008-05-17 16:55 Tom Lane <[email protected]> parent: Jaime Casanova <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Tom Lane @ 2008-05-17 16:55 UTC (permalink / raw) To: Jaime Casanova <[email protected]>; +Cc: pgsql-docs "Jaime Casanova" <[email protected]> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: wal_sync_method @ 2008-05-17 18:27 Jaime Casanova <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Jaime Casanova @ 2008-05-17 18:27 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: pgsql-docs On Sat, May 17, 2008 at 11:55 AM, Tom Lane <[email protected]> wrote: > "Jaime Casanova" <[email protected]> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [DOCS] wal_sync_method @ 2008-05-17 18:45 Tom Lane <[email protected]> parent: Jaime Casanova <[email protected]> 0 siblings, 1 reply; 5+ messages in thread From: Tom Lane @ 2008-05-17 18:45 UTC (permalink / raw) To: Jaime Casanova <[email protected]>; +Cc: [email protected] [ redirecting to -bugs ] "Jaime Casanova" <[email protected]> writes: > On Sat, May 17, 2008 at 11:55 AM, Tom Lane <[email protected]> wrote: >> "Jaime Casanova" <[email protected]> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: [DOCS] wal_sync_method @ 2008-05-17 18:52 Jaime Casanova <[email protected]> parent: Tom Lane <[email protected]> 0 siblings, 0 replies; 5+ messages in thread From: Jaime Casanova @ 2008-05-17 18:52 UTC (permalink / raw) To: Tom Lane <[email protected]>; +Cc: [email protected] On Sat, May 17, 2008 at 1:45 PM, Tom Lane <[email protected]> wrote: > [ redirecting to -bugs ] > > "Jaime Casanova" <[email protected]> writes: >> On Sat, May 17, 2008 at 11:55 AM, Tom Lane <[email protected]> wrote: >>> "Jaime Casanova" <[email protected]> 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 ^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2008-05-17 18:52 UTC | newest] Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-05-17 05:10 wal_sync_method Jaime Casanova <[email protected]> 2008-05-17 16:55 ` Tom Lane <[email protected]> 2008-05-17 18:27 ` Jaime Casanova <[email protected]> 2008-05-17 18:45 ` Tom Lane <[email protected]> 2008-05-17 18:52 ` Jaime Casanova <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox