From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Magnus Hagander <magnus(at)hagander(dot)net> |
Cc: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Chris Travers <chris(at)verkiel(dot)metatrontech(dot)com>, PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>, pgsql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] PostgreSQL on Windows Paper |
Date: | 2007-02-26 19:06:31 |
Message-ID: | 45E32FB7.1070902@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-general |
Magnus Hagander wrote:
>> - It says that 'one should expect performance on Windows to be lower
>> [because of the per-process architecture], especially where large
>> numbers of small queries are made.' That's not really accurate - it will
>> be slower when there are large numbers of short lived connections. Lots
>> of queries in one connection should be fine though.
>
> I believe ou will still see worse performance, because of at least two
> things: context switching is more expensive (much more), and shared
> memory access appears to be more expensive.
> It will be worse if you have short lived connections, of course.
OK, 'relatively speaking'. I think the important part is the connection
setup time, if only because many web apps may setup new connections for
every page (for example) which is where people often seem to come
unstuck and really see the performance hit.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Florian Weimer | 2007-02-26 19:59:56 | Re: Jav Database Performance |
Previous Message | Susanne Ebrecht | 2007-02-26 19:04:58 | Re: successful booth at Fosdem (Brussels) |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrej Ricnik-Bay | 2007-02-26 19:10:25 | Re: [GENERAL] psql : password on Win32 |
Previous Message | RPK | 2007-02-26 18:56:20 | Re: Composite Keys |