Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id E560E9FBD04 for ; Fri, 6 Apr 2007 12:41:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 98926-02 for ; Fri, 6 Apr 2007 12:41:01 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from www.3times25.net (duck.3times25.net [66.23.211.34]) by postgresql.org (Postfix) with ESMTP id 086509FB6A4 for ; Fri, 6 Apr 2007 12:41:01 -0300 (ADT) Received: from [127.0.0.1] (localhost [127.0.0.1]) by www.3times25.net (Postfix) with ESMTP id 07D925401F; Fri, 6 Apr 2007 11:41:01 -0400 (EDT) Message-ID: <46166A0D.10706@3times25.net> Date: Fri, 06 Apr 2007 11:41:01 -0400 From: Geoffrey User-Agent: Thunderbird 1.5.0.8 (X11/20061025) MIME-Version: 1.0 To: pgsql-performance@postgresql.org CC: John Allgood , "J. D. Pearson" , Terry Lee Tucker Subject: more on high load on postgres 7.4.16 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/166 X-Sequence-Number: 24043 We are trying to attack this problem from multiple avenues, thus I'm starting a separate thread. This is with regard to the problem posted via thread: http://archives.postgresql.org/pgsql-performance/2007-04/msg00120.php One thing we are seeing with this move to the new hardware (and rhas 4) is database connection processes that are left over by users who have exited the application. I've attached to these processes via gdb and find they all have the same backtrace. Any insights into what might be causing this issue would be appreciated. Understand, we did not have this problem on the previous hardware running on rhes 3. Here is the backtrace: #0 0x00ba47a2 in _dl_sysinfo_int80 () from /lib/ld-linux.so.2 #1 0x0019f1de in __lll_mutex_lock_wait () from /lib/tls/libpthread.so.0 #2 0x0019ca7a in _L_mutex_lock_23 () from /lib/tls/libpthread.so.0 #3 0xbfed9438 in ?? () #4 0x00c96a4e in pthread_cond_destroy@@GLIBC_2.3.2 () from /lib/tls/libc.so.6 #5 0x00c96a4e in pthread_cond_destroy@@GLIBC_2.3.2 () from /lib/tls/libc.so.6 #6 0x0015243f in critSec::~critSec () from /usr/local/pcm170/libdalkutil.so #7 0x003a48b8 in Comp_ZipFiles () from /usr/local/pcm170/libcompress.so #8 0x00bec527 in exit () from /lib/tls/libc.so.6 #9 0x0816a52f in proc_exit () -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin