Re: [PERFORM] scalability issues on win32

["Claudio Natoli" <claudio(dot)natoli(at)memetrics(dot)com>]

Hi Bruce and all,

sorry guys, I won't have a chance to get to this until after the Christmas break.

If one of the other usual suspects (Dave, Andrew, Magnus, Merlin) can claim it sooner, please do!

Cheers,
Claudio



> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Friday, 17 December 2004 11:25 AM
> To: Claudio Natoli
> Cc: 'Merlin Moncure'; Tom Lane; Win 32 hackers PGSQL
> Subject: Re: [PERFORM] [pgsql-hackers-win32] scalability 
> issues on win32
> 
> 
> 
> Claudio, I need this completed so we can get it into CVS.  
> Without it a
> 8.0.0 version string will fail to compare.
> 
> --------------------------------------------------------------
> -------------
> 
> Claudio Natoli wrote:
> > 
> > Hi Merlin,
> > 
> > > On a probably unrelated note:
> > > Can some other win32 hacker try the following?
> > > Download the latest cvs sources from the server and edit 
> configure,
> > > replacing all instances of '8.0beta5' with '8.0' etc. as is 
> > > will be when released.  Following that do a full 
> make/make clean.  After 
> > > that try and start he server with pg_ctl.exe and tell me 
> if it succeeds or
> > not.
> > 
> > I can confirm this failure.
> > 
> > (in my case at least) pg_ctl is not seeing the full version 
> string of the
> > postmaster in find_other_exec. This is due to the single 
> call to ReadFile in
> > pipe_read_line, which is not returning the entire version 
> string (losing all
> > characters beyond the last decimal point in the version string). A
> > subsequent call to ReadFile picks up the remainder of the 
> string. I don't
> > see that we can rely on a single call returning the entire 
> version string.
> > 
> > If someone can run with this, I've attached initial looping 
> changes for
> > pipe_read_line. However I'm not sure of the correct 
> terminating condition
> > (gets into a call to ReadFile that never returns; the 
> WaitForSingleObject
> > appears insufficient as a precondition for ReadFile) and 
> just don't have
> > time to complete it right now.
> > 
> > Cheers,
> > Claudio
> > 
> > 
> 
> [ Attachment, skipping... ]
> 
> > 
> > ---------------------------(end of 
> broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to choose an 
> index scan if your
> >       joining column's datatypes do not match
> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, 
> Pennsylvania 19073
>