Re: insert performance for win32

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: insert performance for win32
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD7CB@Herge.rcsinc.local
обсуждение исходный текст
Ответ на insert performance for win32  (Marc Cousin <mcousin@sigma.fr>)
Ответы Re: insert performance for win32
Список 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 по дате отправления:

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