pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: postgresql performance list <pgsql-performance@postgresql.org>
Subject: Re: Postgres vs. MySQL
Date: Wed, 24 Nov 2004 17:26:14 +0100
Message-ID: <20041124162614.GB30845@uio.no> (raw)
In-Reply-To: <Pine.LNX.4.61.0411240908400.22359@leda.steelsun.com>
References: <1101302058.338.74.camel@haddock.cmima.csic.es>
	<Pine.LNX.4.61.0411240908400.22359@leda.steelsun.com>

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 */
-- 
Homepage: http://www.sesse.net/



view thread (12+ messages)  latest in thread

Message-ID: <20041124162614.GB30845@uio.no>
Permalink:  ../20041124162614.GB30845@uio.no/
Also on:    postgresql.org/message-id/20041124162614.GB30845@uio.no

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: sgunderson@bigfoot.com
  Subject: Re: Postgres vs. MySQL
  In-Reply-To: <20041124162614.GB30845@uio.no>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox