Re: insert performance for win32 - Mailing list pgsql-performance

From Magnus Hagander
Subject Re: insert performance for win32
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E7F1@algol.sollentuna.se
Whole thread Raw
In response to insert performance for win32  (Marc Cousin <mcousin@sigma.fr>)
Responses Re: insert performance for win32
List pgsql-performance
> > Sorry, I don't follow you here - what do you mean to do? Remove the
> > event completely so we can't wait on it?
> >
>
> 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.

I doubt there will be much performance difference, as you hav eto hit
the kernel anyway (in the recv/send call). But that part is just a guess
:-)


//Magnus

pgsql-performance by date:

Previous
From: Qingqing Zhou
Date:
Subject: Re: insert performance for win32
Next
From: Qingqing Zhou
Date:
Subject: Re: insert performance for win32