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 726603A4548 for ; Thu, 25 Nov 2004 12:38:40 +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 41299-08 for ; Thu, 25 Nov 2004 12:38:33 +0000 (GMT) Received: from net2.micro-automation.com (net2.micro-automation.com [64.7.141.29]) by svr1.postgresql.org (Postfix) with SMTP id C62CB3A4565 for ; Thu, 25 Nov 2004 12:38:33 +0000 (GMT) Received: (qmail 18550 invoked from network); 25 Nov 2004 12:38:19 -0000 Received: from dcdsl.ebox.com (HELO ?192.168.1.36?) (davec@64.7.143.116) by net2.micro-automation.com with SMTP; 25 Nov 2004 12:38:19 -0000 Message-ID: <41A5D23F.3020705@fastcrypt.com> Date: Thu, 25 Nov 2004 07:38:23 -0500 From: Dave Cramer Reply-To: pg@fastcrypt.com Organization: Postgres International User-Agent: Mozilla Thunderbird 0.9 (X11/20041103) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Steinar H. Gunderson" Cc: postgresql performance list Subject: Re: Postgres vs. MySQL References: <1101302058.338.74.camel@haddock.cmima.csic.es> <20041124162614.GB30845@uio.no> In-Reply-To: <20041124162614.GB30845@uio.no> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/400 X-Sequence-Number: 9354 I did some work on RT wrt Postgres for a company and found that their was lots of room for improvement particularly if you are linking requests. The latest RT code hopefully has fixes as a result of this work. Dave Steinar H. Gunderson wrote: >On Wed, Nov 24, 2004 at 09:57:52AM -0500, Christian Fowler wrote: > > >>As for performance, lots of others will probably volunteer tips and >>techniques. In my experience, properly written and tuned applications will >>show only minor speed differences. I have seen several open-source apps >>that "support postgres" but are not well tested on it. Query optimization >>can cause orders of magnitude performance differences. >> >> > >Definitely. My favourite is Request Tracker (we use 2.x, although 3.x is the >latest version), which used something like 5-600 queries (all seqscans since >the database schema only had an ordinary index on the varchar fields in >question, and the queries were automatically searching on LOWER(field) to >emulate MySQL's case-insensitivity on varchar fields) for _every_ page shown. >Needless to say, the web interface was dog slow -- some index manipulation >and a few bugfixes (they had some kind of cache layer which would eliminate >98% of the queries, but for some reason was broken for non-MySQL databases) >later, and we were down to 3-4 index scans, a few orders of magnitude faster. >:-) > >/* Steinar */ > > -- Dave Cramer http://www.postgresintl.com 519 939 0336 ICQ#14675561