Tanking a server with shared memory - Mailing list pgsql-performance

From Martin Foster
Subject Tanking a server with shared memory
Date
Msg-id MSO_c.67623$S55.36987@clgrps12
Whole thread Raw
Responses Re: Tanking a server with shared memory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
I have been experimenting with the  'IPC::Shareable' module under the
native implementation of Perl 5 for OpenBSD 3.5.  While it is not loaded
by default it is a pure pure implementation.

I have tested this module under two machines, one which used to run
PostgreSQL and has a higher then normal amount of SYSV semaphores.  The
other has a normal amount, when testing under the former database server
things load up fine, clients can connect and all information is as it
should.

When I test under the normal setup the machine tanks.    No core dumps,
no errors produced, just a near instant lock-up of the server itself and
that is with a non-privileged user.

While I know this is a Perl issue, but figured I might be able to gain
some insight on how a server could drop without at least generating a
panic.  Any ideas?

    Martin Foster
    Creator/Designer Ethereal Realms
    martin@ethereal-realms.org

pgsql-performance by date:

Previous
From: Kevin Barnard
Date:
Subject: Re: Table UPDATE is too slow
Next
From: Tom Lane
Date:
Subject: Re: Tanking a server with shared memory