| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)killerbytes(dot)com> |
| Cc: | pgsql general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Linux v.s. Mac OS-X Performance |
| Date: | 2007-11-28 17:13:35 |
| Message-ID: | 1196270015.5857.1.camel@mha-laptop.clients.sollentuna.se |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, 2007-11-28 at 07:29 -0700, Scott Ribe wrote:
> > Yes, very much so. Windows lacks the fork() concept, which is what makes
> > PostgreSQL much slower there.
>
> So grossly slower process creation would kill postgres connection times. But
> what about the cases where persistent connections are used? Is it the case
> also that Windows has a performance bottleneck for interprocess
> communication?
There is at least one other bottleneck, probably more than one. Context
switching between processes is a lot more expensive than on Unix (given
that win32 is optimized towards context switching between threads). NTFS
isn't optimized for having 100+ processes reading and writing to the
same file. Probably others..
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2007-11-28 17:18:43 | Re: Select all fields except one |
| Previous Message | Glyn Astill | 2007-11-28 16:17:18 | Re: Error compiling Slony I |