| Lists: | pgsql-bugspgsql-docs |
|---|
| From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
|---|---|
| To: | pgsql-docs(at)postgresql(dot)org |
| Subject: | wal_sync_method |
| Date: | 2008-05-17 05:10:43 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-bugs 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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: wal_sync_method |
| Date: | 2008-05-17 16:55:09 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-docs |
"Jaime Casanova" <systemguards(at)gmail(dot)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
| From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: wal_sync_method |
| Date: | 2008-05-17 18:27:48 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-docs |
On Sat, May 17, 2008 at 11:55 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Jaime Casanova" <systemguards(at)gmail(dot)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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
| Cc: | pgsql-bugs(at)postgreSQL(dot)org |
| Subject: | Re: [DOCS] wal_sync_method |
| Date: | 2008-05-17 18:45:16 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-docs |
[ redirecting to -bugs ]
"Jaime Casanova" <systemguards(at)gmail(dot)com> writes:
> On Sat, May 17, 2008 at 11:55 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> "Jaime Casanova" <systemguards(at)gmail(dot)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
| From: | "Jaime Casanova" <systemguards(at)gmail(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: [DOCS] wal_sync_method |
| Date: | 2008-05-17 18:52:22 |
| Message-ID: | [email protected] |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Lists: | pgsql-bugs pgsql-docs |
On Sat, May 17, 2008 at 1:45 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> [ redirecting to -bugs ]
>
> "Jaime Casanova" <systemguards(at)gmail(dot)com> writes:
>> On Sat, May 17, 2008 at 11:55 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>>> "Jaime Casanova" <systemguards(at)gmail(dot)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