pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedcontrol of benchmarks (was: Thousands of tables)
2+ messages / 2 participants
[nested] [flat]
* control of benchmarks (was: Thousands of tables)
@ 2007-06-06 19:40 Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 1 reply; 2+ messages in thread
From: Andrew Sullivan @ 2007-06-06 19:40 UTC (permalink / raw)
To: pgsql-performance
On Wed, Jun 06, 2007 at 02:01:59PM -0400, Jonah H. Harris wrote:
> They did this for the same reason as everyone else. They don't want
> non-experts tuning the database incorrectly, writing a benchmark paper
> about it, and making the software look bad.
I agree that Oracle is a fine system, and I have my doubts about the
likelihood Oracle will fall over under fairly heavy loads. But I
think the above is giving Oracle Corp a little too much credit.
Corporations exist to make money, and the reason they prohibit doing
anything with their software and then publishing it without their
approval is because they want to control all the public perception of
their software, whether deserved or not. Every user of any large
software system (Oracle or otherwise) has their favourite horror
story about the grotty corners of that software;
commercially-licensed people just aren't allowed to prove it in
public. It's not only the clueless Oracle is protecting themselves
against; it's also the smart, accurate, but expensive corner-case
testers. I get to complain that PostgreSQL is mostly fast but has
terrible outlier performance problems. I can think of another system
that I've used that certainly had a similar issue, but I couldn't
show you the data to prove it. Everyone who used it knew about it,
though.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
A certain description of men are for getting out of debt, yet are
against all taxes for raising money to pay it off.
--Alexander Hamilton
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: control of benchmarks (was: Thousands of tables)
@ 2007-06-06 19:57 Jonah H. Harris <jonah.harris@gmail.com>
parent: Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 0 replies; 2+ messages in thread
From: Jonah H. Harris @ 2007-06-06 19:57 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; +Cc: pgsql-performance
On 6/6/07, Andrew Sullivan <ajs@crankycanuck.ca> wrote:
> But I think the above is giving Oracle Corp a little too
> much credit.
Perhaps. However, Oracle has a thousand or so knobs which can control
almost every aspect of every subsystem. If you know how they interact
with each other and how to use them properly, they can make a huge
difference in performance. Most people do not know all the knobs or
understand what difference each can make given the theory and
architecture of the system, which results in poor general
configurations. Arguably, there is a cost associated with having
someone staffed and/or consulted that has the depth of knowledge
required to tune it in such a manner which goes back to a basic
cost/benefit analysis.
Oracle, while seeming like a one-size-fits-all system, has the same
basic issue as PostgreSQL and everyone else; to get optimum
performance, it has to be tuned specifically for the
application/workload at hand.
> Corporations exist to make money, and the reason they prohibit doing
> anything with their software and then publishing it without their
> approval is because they want to control all the public perception of
> their software, whether deserved or not.
Of course. Which is why audited benchmarks like SPEC and TPC are
around. While they may not represent one's particular workload, they
are the only way to fairly demonstrate comparable performance.
> Every user of any large software system (Oracle or otherwise)
> has their favourite horror story about the grotty corners of
> that software;
Of course, but they also never say why it was caused. With Oracle,
almost all bad-performance cases I've seen are related to improper
tuning and/or hardware; even by experienced DBAs.
--
Jonah H. Harris, Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
33 Wood Ave S, 3rd Floor | jharris@enterprisedb.com
Iselin, New Jersey 08830 | http://www.enterprisedb.com/
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-06-06 19:57 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-06-06 19:40 control of benchmarks (was: Thousands of tables) Andrew Sullivan <ajs@crankycanuck.ca>
2007-06-06 19:57 ` Jonah H. Harris <jonah.harris@gmail.com>
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