X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 279898B9B37 for ; Wed, 16 Feb 2005 08:23:25 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79766-08 for ; Wed, 16 Feb 2005 08:23:21 +0000 (GMT) Received: from fs3.ft.fo (mail-gw.ft.fo [212.55.40.2]) by svr1.postgresql.org (Postfix) with ESMTP id 99EDC8BA105 for ; Wed, 16 Feb 2005 08:23:18 +0000 (GMT) Received: from FT_DOM-MTA by fs3.ft.fo with Novell_GroupWise; Wed, 16 Feb 2005 08:23:17 +0000 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.3 Date: Wed, 16 Feb 2005 08:23:01 +0000 From: "John Jensen" To: , Subject: Re: who is best for support? Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/135 X-Sequence-Number: 16303 Hi Joel, I'm running on a more or less similar hw config and my speed is pretty ok. My base is currently weighing in at 50Gig. You may be having problems with the query itself. Aside from index'es how you construct the query can have a dramatic impact on execution time. I can highly recommend the book "SQL Tuning" by Dan Tow. It's database independant so I think this guy is relly on to the core of the problem. He's got a web site on (I shit you not): http://www.singingsql.com/ Have you looked into the I/O rates (iostat) on your disk devices. One of them might be broken/slow. Good luck John >>> "Joel Fradkin" 02/15/05 8:12 pm >>> Hi, I am trying to get postgres working on a Dell and am finidng my SQL queries run incrediably slow. I have tried to adjust cache and buffers, etc with no luck. Any advice on who would be best for help either it's a config issue or a query issue etc. I been trying for a few weeks to get up to speed and diagnose, but I am running out of time. Joel Fradkin