Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] PostgreSQL on Windows Paper

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 (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-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.


In response to

pgsql-advocacy by date

Next:From: Florian WeimerDate: 2007-02-26 19:59:56
Subject: Re: Jav Database Performance
Previous:From: Susanne EbrechtDate: 2007-02-26 19:04:58
Subject: Re: successful booth at Fosdem (Brussels)

pgsql-general by date

Next:From: Andrej Ricnik-BayDate: 2007-02-26 19:10:25
Subject: Re: [GENERAL] psql : password on Win32
Previous:From: RPKDate: 2007-02-26 18:56:20
Subject: Re: Composite Keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group