public inbox for [email protected]  

help / color / mirror / Atom feed

From: scott.marlowe <[email protected]>
To: Brian Tarbox <[email protected]>
Cc: Brian Tarbox <[email protected]>
Cc: [email protected]
Cc: Rafal Kedziorski <[email protected]>
Cc: [email protected]
Subject: Re: PostgreSQL vs. MySQL
Date: Mon, 7 Jul 2003 13:58:24 -0600 (MDT)
Message-ID: <[email protected]> (raw)
In-Reply-To: <000d01c344b3$db2add00$01000001@trouble>

On Mon, 7 Jul 2003, Brian Tarbox wrote:

> Oddly enough, the particular application in question will have an extremely
> small user base...perhaps a few simultainous users at most.
> 
> As to the testing, I neglected to say early in this thread that my manager
> instructed me _not_ to do further performance testing...so as a good
> consultant I complied.  I'm not going to touch if that was a smart
> instruction to give :-)

But remember, you can always rename your performance testing as 
compliance testing and then it's ok, as long as you don't keep any 
detailed records about the time it took to run the "compliance testing" 
queries.

Definitely look at the output from explain analyze select ... to see what 
the planner THINKS the query is gonna cost versus what it really costs.  
If you see a huge difference between, say estimated rows and actual rows, 
or some other value, it points to the analyzer not getting the right data 
for the planner.  You can adjust the percentage of a table sampled with 
alter table to force more data into analyze.

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

* 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