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

From Magnus Hagander
Subject Re: insert performance for win32
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCE92E7F5@algol.sollentuna.se
Whole thread Raw
In response to insert performance for win32  (Marc Cousin <mcousin@sigma.fr>)
List 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 by date:

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