From: Marc Cousin <mcousin@sigma.fr>
Cc: pgsql-performance@postgresql.org
Subject: Re: insert performance for win32
Date: Tue, 6 Sep 2005 17:13:41 +0200
Message-ID: <200509061713.41559.mcousin@sigma.fr> (raw)
In-Reply-To: <6EE64EF3AB31D5448D0007DD34EEB3417DD27E@Herge.rcsinc.local>
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD27E@Herge.rcsinc.local>
>
> In my experience win32 is par with linux generally with a few gotchas on
> either side. Are your times with fsync=no? It's much harder to give
> apples-apples comparison with fsync=on for various reasons.
It is with fsync=off on windows, fsync=on on linux
>
> Are you running stats_command_string=on? Try disabling and compare
> results.
Deactivated on windows, activated on linux
> Is your loading app running locally or on the server?
Yes
>
> I am very interesting in discovering sources of high cpu load problems
> on win32. If you are still having problems could you get a gprof
> profile together? There is a recent thread on win32-hackers discussing
> how to do this.
I'll give it a look....
>
> Merlin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mcousin@sigma.fr
Subject: Re: insert performance for win32
In-Reply-To: <200509061713.41559.mcousin@sigma.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox