Connection terminates but postmaster proc lives on...?
От | Jeff Madison |
---|---|
Тема | Connection terminates but postmaster proc lives on...? |
Дата | |
Msg-id | 007201c1e63e$aad57040$58c2d0cd@JEFF обсуждение исходный текст |
Ответы |
Re: Connection terminates but postmaster proc lives on...?
|
Список | pgsql-admin |
I have seen several postings in the list archives regarding this exact issue but have never seen any response or resolution. We are running pgsql 7.1.3 installed from the RedHat RPM on RedHat Linux 7.2. We are running a fairly large accounting application written in PERl using the PERL DBI and DBD:Postgres on PERL 5.6.1. What we are seeing is when people terminate the application in the middle of a query many times postmaster does not see the connection terminate or at least ignores it and then proceeds to take a large amount of system resources and never dies. It only takes 5 or 6 of these postmaster processes to make the system unusable since each one will take 25 to 35% of the processor capacity of the system. Eventually the system will just cease to respond - after 18 to 24 hours. This is a web based application so it does happen very frequently where someone will get tired of waiting for a page to return and just close the browser. We have adjusted the max_connection, shared_buffers, fsync=false and increased the amount of shared memory in the kernel to 1GB. Thanks, Jeff
В списке pgsql-admin по дате отправления: