Re: insert performance for win32

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: insert performance for win32
Дата
Msg-id 13733.1131117709@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: insert performance for win32  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Searching union views not using indices
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: insert performance for win32