Re: Server hangs on multiple connections

I think you've fixed it. With your patch, and a simple

$ ./configure
$ make
$ make check
# make install

the check works and all tests (except geometry on floating point stuff)
pass; and after installing, I can really hammer the server and it
doesn't hang. Looks like users on Yellow Dog Linux multi-CPU PowerPC
platforms won't have this problem anymore ... that is, when the next
person besides me decides to try it. :-)

This whole exercise was well worth my time, and I get the added bonus
of not having to switch machines. I know you spent a lot of time on it
and I greatly appreciate your care and responsiveness.

Many thanks - feel free to ask me to check anything else on this
platform you would like to see.

David

On Friday, Sep 20, 2002, at 20:40 US/Eastern, Tom Lane wrote:

> Well, the long and the short of it seems to be that no one before you
> ever tried to run Postgres on a multi-CPU PowerPC machine :-(
>
> Some digging around on the net made it clear that we were missing
> synchronization instructions that are critical for access to shared
> memory in a multi-CPU system. I have applied the attached patch to
> CVS tip (7.3beta2-almost). It looks like it will apply cleanly to
> 7.2.*, so please try it out (with optimization re-enabled) and let
> us know what you see!

[snip]