Re: insert performance for win32 - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: insert performance for win32
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD7CD@Herge.rcsinc.local
Whole thread Raw
In response to insert performance for win32  (Marc Cousin <mcousin@sigma.fr>)
List pgsql-performance
>
> "Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> > yeah.  I'm guessing problem is in the mingw flex/bison (which I
really,
> > really hope is not the case) or some other win32 specific block of
code.
> > I'm snooping around there...
>
> Maybe I'm confused here, but I thought we had established that the
local
> and remote cases behave differently for you?  If so I'd suppose that
it
> must be a networking issue, and there's little point in looking inside
> psql.
>
The local case is *worse*...presumably because psql is competing with
the server for cpu time...cpu load is pegged at 100%.  On the remote
case, I'm getting 50-60% cpu load which is way to high.  The problem is
definitely in psql.

Merlin


pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: insert performance for win32
Next
From: Michal Taborsky
Date:
Subject: Re: Searching union views not using indices