X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A2526533C8 for ; Wed, 20 Apr 2005 15:48:32 -0300 (ADT) 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 07471-03 for ; Wed, 20 Apr 2005 18:48:31 +0000 (GMT) Received: from davinci.ethosmedia.com (server227.ethosmedia.com [209.128.84.227]) by svr1.postgresql.org (Postfix) with ESMTP id 2BC5152D90 for ; Wed, 20 Apr 2005 15:48:30 -0300 (ADT) X-EthosMedia-Virus-Scanned: no infections found Received: from [64.81.245.111] (account josh@agliodbs.com HELO temoku.sf.agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 7258775; Wed, 20 Apr 2005 11:50:26 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "Joel Fradkin" Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon Date: Wed, 20 Apr 2005 11:53:35 -0700 User-Agent: KMail/1.7.1 Cc: pgsql-performance@postgresql.org References: <003201c545d4$ef3f3f10$797ba8c0@jfradkin> In-Reply-To: <003201c545d4$ef3f3f10$797ba8c0@jfradkin> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200504201153.36188.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.048 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/519 X-Sequence-Number: 11916 Joel, > I did not see any marked improvement, but I don=92t think my issues are > related to the hardware. If you won't believe it, then we certainly can't convince you. AFAIK your = bad=20 view is a bad query plan made worse by the Dell's hardware problems. > I am giving up on postgres and three developers two months of work and > trying MYSQL. I'd suggest testing your *whole* application and not just this one query. = And=20 remember that you need to test InnoDB tables if you want transactions. > > I have posted several items and not got a response (not that I expect fol= ks > to drop everything). I want to thank everyone who has been of help and > there are several. Hmmm ... I see about 25 responses to some of your posts on this list. =20 Including ones by some of our head developers. That's more than you'd get= =20 out of a paid MSSQL support contract, I know from experience. If you want anything more, then you'll need a "do-or-die" contract with a=20 support company. If your frustration is because you can't find this kind of= =20 help than I completely understand ... I have a waiting list for performance= =20 contracts myself. (and, if you hired me the first thing I'd tell you is to= =20 junk the Dell) > I really like the environment and feel I have learned a lot in the past f= ew > months, but bottom line for me is speed. We bought a 30K Dell 6650 to get > better performance.=20 Would have been smart to ask on this list *before* buying the Dell, hey? E= ven=20 a Google of this mailing list would have been informative. > I chose PG because MSSQL was 70K to license. I believe=20 > the MYSQL will be 250.00 to license for us, but I may choose the 4k > platinum support just to feel safe about having some one to touch base wi= th > in the event of an issue. Hmmm ... you're willing to pay MySQL $4k but expect the PG community to sol= ve=20 all your problems with free advice and a couple $100 with CMD? I sense an= =20 apples vs. barca loungers comparison here ... > I am not sure I am walking away feeling real good about > postgres, because it just should not take a rocket scientist to get it to > work, and I used to think I was fairly smart and could figure stuff out a= nd > I hate admitting defeat (especially since we have everything working with > postgres now). While I understand your frustration (I've been frustrated more than a few=20 times with issues that stump me on Linux, for example) it's extremely unfai= r=20 to lash out at a community that has provided you a lot of free advice becau= se=20 the advice hasn't fixed everything yet. By my reading, you first raised yo= ur=20 query issue 6 days ago. 6 days is not a lot of time for getting *free*=20 troubleshooting help by e-mail. Certainly it's going to take more than 6 da= ys=20 to port to MySQL. =20 =2D-=20 =2D-Josh Josh Berkus Aglio Database Solutions San Francisco