Hi,
I have in my logs the following lines :
jui 7 10:40:07 poseidon logger: FATAL: Non-superuser connection
limit exceeded
jui 7 10:40:44 poseidon logger: LOG: pq_recvbuf: unexpected EOF
on client connection
jui 7 10:40:53 poseidon last message repeated 23 times
What does it means ? Particulary the "pg_recvbuf" line ?
when this happen, DB is very very very slow and I have to restart it...
Version is 7.3.2 on a dual 2Ghz Xenon with 1go RAM, SCSI RAID 1
drives, Red Hat 8.0
Buffers are set to -B90846
Num of postgres is -N255
And sort meme is -S131072
There are a lot of updates and select on this DB.
Numbers of transaction/sec is approx. 60.
We do a vacuum -v -a -z every 12 hours
and a full vacuum each week.
Thanks for your help !
Jean-Arthur Silve
EuroVox
4, Place Félix Eboué
75583 Paris Cedex 12
T : +33 1 44670505
F : +33 1 44670519