Re: insert performance for win32

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: insert performance for win32
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3417DD7D3@Herge.rcsinc.local
обсуждение исходный текст
Ответ на insert performance for win32  (Marc Cousin <mcousin@sigma.fr>)
Ответы Re: insert performance for win32  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Nailed it.

problem is in mainloop.c -> setup_cancel_handler.  Apparently you can
have multiple handlers and windows keeps track of them all, even if they
do the same thing.  Keeping track of so many system handles would
naturally slow the whole process down.  Commenting that line times are
flat as a pancake.  I am thinking keeping track of a global flag would
be appropriate.


Merlin


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

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