Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B39D99FA4BB for ; Tue, 2 Jan 2007 19:09:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 71402-07 for ; Tue, 2 Jan 2007 19:09:19 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 892FA9FA4B6 for ; Tue, 2 Jan 2007 19:09:23 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.6/8.13.6) with ESMTP id l02N9L4K022513; Tue, 2 Jan 2007 18:09:21 -0500 (EST) To: Erik Jones cc: pgsql-performance@postgresql.org Subject: Re: More 8.2 client issues (Was: [Slow dump?) In-reply-to: <459AD5A8.7030102@myemma.com> References: <459AD5A8.7030102@myemma.com> Comments: In-reply-to Erik Jones message dated "Tue, 02 Jan 2007 15:59:04 -0600" Date: Tue, 02 Jan 2007 18:09:21 -0500 Message-ID: <22512.1167779361@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/30 X-Sequence-Number: 22631 Erik Jones writes: > Hmm... This gets stranger and stranger. When connecting to the > database with the psql client in 8.2's bin directory and using commands > such as \d the client hangs, or takes an extremely long time. Hangs at what point? During connection? Try strace'ing psql (or whatever the Solaris equivalent is) to see what it's doing. regards, tom lane