| From: | Marc Cousin <mcousin(at)sigma(dot)fr> |
|---|---|
| To: | Undisclosed(dot)Recipients: ; |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: insert performance for win32 |
| Date: | 2005-09-06 15:13:41 |
| Message-ID: | 200509061713.41559.mcousin@sigma.fr |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-09-06 15:32:00 | Re: Poor performance of delete by primary key |
| Previous Message | Matthew Nuzum | 2005-09-06 15:09:10 | Re: Postgresql Hardware - Recommendations |