From: Brian Fehrle <brianf@consistentstate.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: General key issues when comparing performance between PostgreSQL and oracle
Date: Tue, 16 Jul 2013 10:51:42 -0600
Message-ID: <51E57A1E.9020309@consistentstate.com> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi all (Hopefully this is the correct mailing list for this).
I'm working on performance tuning a host of queries on PostgreSQL 9.2
from an application, each query having its own issues and fixes, however
from what I understand this application runs the exact same queries on
the exact same data in half the time on oracle and SQL server.
Are there any known differences between the database systems in terms of
query planners or general operations (sorting, unions) that are notable
different between the systems that would make postgres slow down when
executing the exact same queries?
It's worth noting that the queries are not that good, they have issues
with bad sub-selects, Cartesian products, and what looks like bad query
design in general, so the blame isn't completely with the database being
slow, but I wonder what makes oracle preform better when given
not-so-great queries?
I know this is rather general and high level, but any tips or experience
anyone has would be appreciated.
Thanks,
- Brian F
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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: brianf@consistentstate.com
Subject: Re: General key issues when comparing performance between PostgreSQL and oracle
In-Reply-To: <51E57A1E.9020309@consistentstate.com>
* 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