Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-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

pgsql-hackers by date

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

pgsql-hackers-win32 by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group