Re: insert performance for win32

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: insert performance for win32
Дата
Msg-id 14316.1131122032@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: insert performance for win32  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
Список pgsql-performance
"Merlin Moncure" <merlin.moncure@rcsonline.com> writes:
> ok, mingw gprof is claiming MainLoop is a culprit here,

The only thing I can see that would be different for Windows is the
SetConsoleCtrlHandler kernel call ... could that be expensive?  Why
do we have either sigsetjmp or setup_cancel_handler inside the per-line
loop, rather than just before it?

There is a lot of stuff in MainLoop that doesn't seem like it really
needs to be done on every single line, particularly not the repeated
fetching of psql variables that couldn't possibly change except inside
HandleSlashCmds.  But that all ought to be the same on Unix or Windows.

            regards, tom lane

В списке pgsql-performance по дате отправления:

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