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

From Tom Lane
Subject Re: insert performance for win32
Date
Msg-id 13733.1131117709@sss.pgh.pa.us
Whole thread Raw
In response to Re: insert performance for win32  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-performance
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> It doesn't, and it doesn't. :/  Ok, here's where it gets interesting. I
> removed all the newlines from the test output (dump.sql) and got flat
> times ;).

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?

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.

            regards, tom lane

pgsql-performance by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Searching union views not using indices
Next
From: "Merlin Moncure"
Date:
Subject: Re: insert performance for win32