| From: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: insert performance for win32 |
| Date: | 2005-11-04 15:41:23 |
| Message-ID: | 6EE64EF3AB31D5448D0007DD34EEB3417DD7CD@Herge.rcsinc.local |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
>
> "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michal Taborsky | 2005-11-04 15:55:59 | Re: Searching union views not using indices |
| Previous Message | Tom Lane | 2005-11-04 15:36:34 | Re: insert performance for win32 |