FW: [GENERAL] 48 postmaster processes and a hang? [2] - Mailing list pgsql-general

From Daryl W. Dunbar
Subject FW: [GENERAL] 48 postmaster processes and a hang? [2]
Date
Msg-id 009901be547a$4d7c7d20$1445e59b@ddunbar.eni.net
Whole thread Raw
List pgsql-general
Attachment - Duh!

-----Original Message-----

Hello,

I am running 6.4.2 on Sparc/Solaris 2.7.  Occasionally (far more
often than I would like - which is never :), the postmaster refuses
connections.  Upon investigation, there are 48 postmaster processes
running.  If one kills the parent and restarts, all is well for some
time.  Attached is a chunk of output from postmaster, unfortunately
it does not timestamp, so it is hard to see when what happened.  I'm
most disturbed about the device space message.  None of my disks are
even close to full, nor have been...

Help! Advice? Ways to gather further info?

Also, is the 48 number configurable?  It almost looks as though that
is the maximum number of outstanding queries I can have at one time?

Thanks,

DwD
--
Daryl W. Dunbar
http://www.com, Where the Web Begins!
mailto:daryl@www.com


Attachment

pgsql-general by date:

Previous
From: "Daryl W. Dunbar"
Date:
Subject: 48 postmaster processes and a hang?
Next
From: "Jackson, DeJuan"
Date:
Subject: RE: [GENERAL] pqReadData() -- backend closed the channel unexpect edly.