| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
| Cc: | "MikeSmialek2(at)Hotmail(dot)com" <mikesmialek2(at)hotmail(dot)com>, pgsql-hackers-win32(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org, "Magnus Hagander" <mha(at)sollentuna(dot)net> |
| Subject: | Re: [PERFORM] Performance on Win32 vs Cygwin |
| Date: | 2004-10-15 17:55:11 |
| Message-ID: | 11490.1097862911@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers-win32 pgsql-performance |
"Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> writes:
> I'm pretty certain that previous to 8.0 no win32 based postgesql
> properly sync()ed the files. Win32 does not have sync(), and it is
> impossible to emulate it without relying on the application to track
> which files to sync. 8.0 does this because it fsync()s the files
> individually. Therefore, benchmarking fsync=on on 8.0 to a <8.0 version
> of windows is not apples to apples. This includes, by the way, the SFU
> based port of postgresql because they didn't implement sync() there,
> either.
This is all true, but for performance testing I am not sure that you'd
notice much difference, because the sync or lack of it only happens
within checkpoints.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2004-10-16 15:30:12 | get_progname and .exe suffix |
| Previous Message | Merlin Moncure | 2004-10-15 16:22:40 | Re: Performance on Win32 vs Cygwin |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-10-15 18:06:18 | Re: Does PostgreSQL run with Oracle? |
| Previous Message | Tom Lane | 2004-10-15 17:51:05 | Re: Tuning shared_buffers with ipcs ? |