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 865A35362B for ; Sat, 23 Apr 2005 11:11:33 -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 42873-10 for ; Sat, 23 Apr 2005 14:11:24 +0000 (GMT) Received: from vms044pub.verizon.net (vms044pub.verizon.net [206.46.252.44]) by svr1.postgresql.org (Postfix) with ESMTP id CFA4854247 for ; Sat, 23 Apr 2005 11:11:23 -0300 (ADT) Received: from jfradkin ([63.162.100.127]) by vms044.mailsrvcs.net (Sun Java System Messaging Server 6.2 HotFix 0.04 (built Dec 24 2004)) with ESMTPA id <0IFE00GMOKR2K176@vms044.mailsrvcs.net> for pgsql-performance@postgresql.org; Sat, 23 Apr 2005 09:11:27 -0500 (CDT) Date: Sat, 23 Apr 2005 10:11:28 -0400 From: "Joel Fradkin" Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon In-reply-to: <20050423021107.GX58835@decibel.org> To: "'Jim C. Nasby'" Cc: "'Alvaro Herrera'" , "'Andreas Pflug'" , "'Dave Page'" , , , "'Joshua D. Drake'" , , "'Steve Hatt'" Message-id: <001701c5480e$57e7fad0$797ba8c0@jfradkin> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Mailer: Microsoft Outlook, Build 10.0.6626 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: quoted-printable Importance: Normal X-Priority: 3 (Normal) X-MSMail-priority: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/643 X-Sequence-Number: 12040 I would very, very strongly encourage you to run multi-user tests before deciding on mysql. Mysql is nowhere near as capable when it comes to concurrent operations as PostgreSQL is. From what others have said, it doesn't take many concurrent operations for it to just fall over. I can't speak from experience because I avoid mysql like the plague, though. :) I am just testing the water so to speak, if it cant handle single user = tests then multiple user tests are kind of a waste of time. I am trying to de-normalize my view into a table to see if I can get my = app to work. It is a good idea anyway but raises a ton of questions about dealing with the data post a case being closed etc; also on multiple = child relationships like merchandise and payments etc. I did do a test of all three (MSSQL, MYSQL,and postgres) in aqua studio = , all on the same machine running the servers and found postgres beat out MYSQL, but like any other test it may have been an issue with aqua = studio and mysql in any case I have not made a decision to use mysql I am still researching fixes for postgres. I am waiting to here back from Josh on using cursors and trying to = flatten long running views.=20 I am a little disappointed I have not understood enough to get my = analyzer to use the proper plan, we had to set seqscan off to get the select from response_line to work fast and I had to turn off merge joins to get = assoc list to work fast. Once I am up I can try to learn more about it, I am = so glad there are so many folks here willing to take time to educate us = newb's.