| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Shelby Cain <alyandon(at)yahoo(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-hackers-win32(at)postgresql(dot)org |
| Subject: | Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming |
| Date: | 2004-08-20 19:49:33 |
| Message-ID: | 1866.1093031373@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers-win32 |
Shelby Cain <alyandon(at)yahoo(dot)com> writes:
> On a hunch, I turned fsync off and the performance
> jumped up to around the same performance I was getting
> running the cygwin 7.4.x port.
Ah-hah. The win32 hackers should confirm this, but my recollection is
that sync/fsync are no-ops under Cygwin (one of the several reasons
we would never recommend that port for production use). So this would
fit the assumption that the 7.4 code was simply not syncing.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Lester | 2004-08-20 19:59:27 | Re: Postgres filling up hard drive with swap files |
| Previous Message | Tom Lane | 2004-08-20 19:43:15 | Re: Postgres filling up hard drive with swap files |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2004-08-20 19:56:42 | Re: postmaster.pid |
| Previous Message | Shelby Cain | 2004-08-20 19:42:00 | Re: Postgresql 8.0 beta 1 - strange cpu usage statistics and slow vacuuming |