Re: insert performance for win32

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:31:11
Message-ID: 6EE64EF3AB31D5448D0007DD34EEB3417DD7CB@Herge.rcsinc.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-11-04 15:31:34 Re: Searching union views not using indices
Previous Message Tom Lane 2005-11-04 15:21:49 Re: insert performance for win32