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

From Merlin Moncure
Subject Re: insert performance for win32
Date
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD7CB@Herge.rcsinc.local
Whole thread Raw
In response to insert performance for win32  (Marc Cousin <mcousin@sigma.fr>)
Responses Re: insert performance for win32
List pgsql-performance
> That's bizarre ... I'd have thought a very long line would be more
> likely to trigger internal performance problems than the original.
>
> What happens if you read the file with "psql -f dump.sql" instead
> of cat/stdin?

non-flat.  Also ran via \i and got non flat times.

> BTW, I get flat times for your psql test case on Unix, again both with
> local and remote client.  So whatever is going on here, it's
> Windows-specific.

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...

Merlin

pgsql-performance by date:

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