Skip site navigation (1) Skip section navigation (2)

Re: Postgres vs. MySQL

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
Cc: postgresql performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Postgres vs. MySQL
Date: 2004-11-25 12:38:23
Message-ID: 41A5D23F.3020705@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-performance
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


In response to

pgsql-performance by date

Next:From: Richard HuxtonDate: 2004-11-25 12:54:46
Subject: Re: Trigger before insert
Previous:From: ON.KGDate: 2004-11-25 11:37:40
Subject: Trigger before insert

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group