Received: from localhost (unknown [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 3D7D82E1FFA
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 14 Nov 2007 14:35:21 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 82594-03 for <pgsql-sql-postgresql.org@postgresql.org>;
	Wed, 14 Nov 2007 14:35:09 -0400 (AST)
Received: from web31806.mail.mud.yahoo.com (web31806.mail.mud.yahoo.com
	[68.142.207.69]) by postgresql.org (Postfix) with SMTP id 7FF1C2E1C3A
	for <pgsql-sql@postgresql.org>; Wed, 14 Nov 2007 14:35:16 -0400 (AST)
Received: (qmail 69179 invoked by uid 60001); 14 Nov 2007 18:35:15 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Message-ID;
	b=MZ/tINiXq3P9UcJq3CfzqhTxOcHOErI2mmYKVOhboDjoeZcDXyujosX1VCFw7L5/P+/2/kRNOXh1GqZyjBPzXHiXm6vTM8+cJQLgPBsoF2SUdeexd+3fWYOeqh71I6IpJBdoIL8g6S/8m5UThorv55++yuvbsIRoP9MQgAdjzwc=;
X-YMail-OSG: 
 FSMGs1sVM1lGIB66.sMP1usqyqjTniqNXrZWQGwudZhlKVueVjtcfajanjFB3UwMBnm8xxt3rQ--
Received: from [12.180.237.138] by web31806.mail.mud.yahoo.com via HTTP;
	Wed, 14 Nov 2007 10:35:15 PST
X-Mailer: YahooMailWebService/0.7.158
Date: Wed, 14 Nov 2007 10:35:15 -0800 (PST)
From: Richard Broersma Jr <rabroersma@yahoo.com>
Subject: Re: postgres bogged down beyond tolerance
To: pgsql-sql@postgresql.org, Tena Sakai <tsakai@gallo.ucsf.edu>
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C03062D99@egcrc-ex01.egcrc.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Message-ID: <167567.67421.qm@web31806.mail.mud.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200711/74
X-Sequence-Number: 29602

--- On Wed, 11/14/07, Tena Sakai <tsakai@gallo.ucsf.edu> wrote:
> The postgres server I have (on redhat linux with recent
> Dell hardware) is running terribly slow.

Hello Tena,

If you do not get a response to your question regarding performance, you might try resending this email to : pgsql-performance@postgresql.org .

This mailing list ( pgsql-sql@postgresql.org ) is really intended for discussions of how to construct SQL queries to achieve desired results in a PostgreSQL database.

Regards,
Richard Broersma Jr.