Re: insert performance for win32

Lists: pgsql-performance
From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
Cc: "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: insert performance for win32
Date: 2005-11-03 20:30:30
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCE92E7EF@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-performance

> > > Both win32 send/recv have pgwin32_poll_signals() in them.
> > > This is glorified WaitForSingleObjectEx on global
> > > pgwin32_signal_event. This is probably part of the problem.
> > > Can we work some of the same magic you put into check interrupts
> > > macro?
> > >
> >
> > Uh, we already do that, don't we?
> >
> http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/port/win3
> > 2/
> > socket.c?rev=1.10
> > has:
> >
>
> Yeah, we did this. I am thinking of just use simple mechanism
> of the win32 sockets, which could not pick up signals, but I
> would like to see if there is any difference -- do you think
> there is any point to try this?

Sorry, I don't follow you here - what do you mean to do? Remove the
event completely so we can't wait on it?

//Magnus


From: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>
To: Magnus Hagander <mha(at)sollentuna(dot)net>
Cc: Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: insert performance for win32
Date: 2005-11-03 20:34:55
Message-ID: Pine.LNX.4.58.0511031531320.15665@josh.db
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-performance

On Thu, 3 Nov 2005, Magnus Hagander wrote:

>
> 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?

Regards,
Qingqing