public inbox for [email protected]  

help / color / mirror / Atom feed

From: Rod Taylor <[email protected]>
To: Brian Tarbox <[email protected]>
Cc: Shridhar Daithankar <[email protected]>
Cc: Postgresql Performance <[email protected]>
Subject: Re: PostgreSQL vs. MySQL
Date: 04 Jul 2003 10:34:20 -0400
Message-ID: <1057329259.40425.36.camel@jester> (raw)
In-Reply-To: <01bf01c34235$a4c8aa60$01000001@trouble>
References: <01bf01c34235$a4c8aa60$01000001@trouble>

> Please understand the limits of how much information a consultant can submit
> to an open list like this about a client's confidential information.  I've
> answered every question I _can_ answer and when I get hostility in response
> all I can do is sigh and move on.

Is there any chance you could show us an EXPLAIN ANALYZE output of the
poor performing query in question?

> I'm sorry if Shridhar is upset that I can't validate his favorite db but ad
> hominin comments aren't helpful.

It was me who gave the comment based upon previous threads which
requested information that had gone unanswered (not even a response
stating such information could not be provided).

The database you describe is quite small, so I'm not surprised MySQL
does well with it. That said, it isn't normal to experience poor
performance with PostgreSQL unless you've stumbled upon a poor spot (IN
based sub-queries used to be poor performing, aggregates can be slow,
mismatched datatypes, etc.).

Output of EXPLAIN ANALYZE of a contrived query representative of the
type of work done (that demonstrates the problem) with renamed tables
and columns would go a long way to helping us help you.



Attachments:

  [application/pgp-signature] signature.asc (187B, 2-signature.asc)
  download

view thread (66+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: PostgreSQL vs. MySQL
  In-Reply-To: <1057329259.40425.36.camel@jester>

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

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