Re: insert performance for win32

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: insert performance for win32
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E7F5@algol.sollentuna.se
обсуждение исходный текст
Ответ на insert performance for win32  (Marc Cousin <mcousin@sigma.fr>)
Список pgsql-performance
> > > I'd like to use the win32 provided recv(), send()
> functions instead
> > > of redirect them to pgwin32_recv()/pgwin32_send(), just
> like libpq
> > > does. If we do this, we will lose some functionalities,
> but I'd like
> > > to see the performance difference first. -- do you think
> that will
> > > be any difference?
> >
> > Doesn't work, really. It will no longer be possible to send
> a signal
> > to an idle backend. The idle backend will be blocking on recv(),
> > that's how it works. So unless we can get around that
> somehow, it's a
> > non-starter I think.
>
> Yeah, agreed.  An alternative is set tiemout like 100 ms or
> so. When timeout happens, check the signals. But I guess you
> will be strongly against it.

Not on principle, but I don't think it'll give us enough gain for the
cost. But if it does, I'm certainly not against it.



//Magnus

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

Предыдущее
От: Qingqing Zhou
Дата:
Сообщение: Re: insert performance for win32
Следующее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: insert performance for win32