Re: Changing the default wal_sync_method to open_sync for Win32?

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Bruce Momjian" <pgman(at)candle(dot)pha(dot)pa(dot)us>, "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>, <pgsql-hackers-win32(at)postgresql(dot)org>, "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>
Subject: Re: Changing the default wal_sync_method to open_sync for Win32?
Date: 2005-03-17 09:05:41
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E472BBF1@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-hackers-win32

> -----Original Message-----
> From: pgsql-hackers-owner(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org] On Behalf Of Bruce Momjian
> Sent: 17 March 2005 04:20
> To: Magnus Hagander
> Cc: Tom Lane; pgsql-hackers(at)postgresql(dot)org;
> pgsql-hackers-win32(at)postgresql(dot)org; Merlin Moncure
> Subject: [HACKERS] Changing the default wal_sync_method to
> open_sync for Win32?
>
> 1. Should it be the default wal_sync_method for Win32?

Yes.

> 2. Another question is what to do with 8.0.X? Do we
> backpatch this for
> Win32 performance? Can we test it enough to know it will work well?
> 8.0.2 is going to have a more rigorous testing cycle because of the
> buffer manager changes.

This question was asked earlier, and iirc, a few people said yes, and
no-one said no. I'm most definitely in the yes camp.

Regards, Dave.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2005-03-17 09:11:51 Re: Changing the default wal_sync_method to open_sync for
Previous Message Magnus Hagander 2005-03-17 09:05:39 Re: [pgsql-hackers-win32] win32 performance - fsync question

Browse pgsql-hackers-win32 by date

  From Date Subject
Next Message Dave Page 2005-03-17 09:11:51 Re: Changing the default wal_sync_method to open_sync for
Previous Message Magnus Hagander 2005-03-17 09:05:39 Re: [pgsql-hackers-win32] win32 performance - fsync question