| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | 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, Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com> |
| Subject: | Re: [pgsql-hackers-win32] win32 performance - fsync question |
| Date: | 2005-02-24 15:02:15 |
| Message-ID: | 421DEC77.70500@familyhealth.com.au |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-hackers-win32 |
> My results are:
> Fisrt, baseline:
> * Linux, with fsync (default), write-cache disabled: no data corruption
> * Linux, with fsync (default), write-cache enabled: usually no data
> corruption, but two runs which had
> * Win32, with fsync, write-cache disabled: no data corruption
> * Win32, with fsync, write-cache enabled: no data corruption
> * Win32, with osync, write cache disabled: no data corruption
> * Win32, with osync, write cache enabled: no data corruption. Once I
> got:
> 2005-02-24 12:19:54 LOG: could not open file "C:/Program
> Files/PostgreSQL/8.0/data/pg_xlog/000000010000000000000010" (log file 0,
> segment 16): No such file or directory
In case anyone is wondering, you can turn off write caching on FreeBSD,
for a terrible perfomance loss...
http://freebsd.active-venture.com/handbook/configtuning-disk.html#AEN8015
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-24 15:15:50 | Re: invalid multibyte character for locale |
| Previous Message | Christopher Kings-Lynne | 2005-02-24 14:54:02 | Re: [pgsql-hackers-win32] win32 performance - fsync question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-24 15:21:16 | Re: [pgsql-hackers-win32] win32 performance - fsync question |
| Previous Message | Christopher Kings-Lynne | 2005-02-24 14:54:02 | Re: [pgsql-hackers-win32] win32 performance - fsync question |