4 ms·

- query hints - planner hints - better statistics (including ways to manually create statistics) - no vacuum - automatic planner adjustment when true cost w

by aeyes 6y ago

- query hints - planner hints - better statistics (including ways to manually create statistics) - no vacuum - automatic planner adjustment when true cost was off - better planning for prepared statements - active-active clustering with RAC - vendor support for running on SAN including snapshots - usable query analysis tools provided by the vendor (pg_stat_statements alone doesn't cut it) - datapump much faster than pg_dump - better connection management - out of the box backup tooling edit: I haven't used Oracle in 4 years, all of that was available to me back then.

Someone1234 6y ago
Several of these are "features" exist to fix broken parts of Oracle (like query/planner hints, planner adjustment, etc). Officially (per Oracle) the planner should be good enough so you never need to use a hint, but realistically all of these are "features" because the built-in systems aren't good. So, granted, other databases don't have Oracle's hacks to fix their broken stuff but I'm not sure why that is an argument FOR using Oracle rather than AGAINST. Hints are fragile hacks.
- vbezhenar 6y ago
  So what do you do when you encounter bug in Postgres planner? File a bug and wait for months or years until fix is released? Hack postgres source and fork it? Using hints sounds like a more sane solution. Nobody's perfect. Being able to work around is better than not being able to.
leandrod 6y ago
RAC and hints are antifeatures.
- modoc 6y ago
  What DB has a better active-active HA cluster option than RAC? I love me some Postgres and MariaDB but I've never seen anything come close to RAC for making high volume queries against active-active just work.
castorp 6y ago
What's the difference between a query hint and a planner hint? > automatic planner adjustment when true cost was off More often than not, this "automatic adjustment" makes things worse. > active-active clustering with RAC But it's still shared storage, which doesn't really make it a true cluster in my opinion > out of the box backup tooling While this is true, there are several (free) backup tools that are easy to install and use and can rival rman's features.
- aeyes 6y ago
  A query hint is a clause you put into the query to make the planner execute the query in a certain way. Planner hint might not be the right term, Oracle has tools to show you different execution plans and to force a plan without touching the query on the application side. I'm not sure why shared storage would be a problem, the world runs on SANs and making them redundant is pretty much a solved problem. For running a RAC cluster you are required to have at least two network paths for each cluster node. Furthermore cluster communication is separated from storage communication.

by aeyes 6y ago

Someone1234 6y ago

Several of these are "features" exist to fix broken parts of Oracle (like query/planner hints, planner adjustment, etc). Officially (per Oracle) the planner should be good enough so you never need to use a hint, but realistically all of these are "features" because the built-in systems aren't good. So, granted, other databases don't have Oracle's hacks to fix their broken stuff but I'm not sure why that is an argument FOR using Oracle rather than AGAINST. Hints are fragile hacks.

vbezhenar 6y ago
So what do you do when you encounter bug in Postgres planner? File a bug and wait for months or years until fix is released? Hack postgres source and fork it? Using hints sounds like a more sane solution. Nobody's perfect. Being able to work around is better than not being able to.

leandrod 6y ago

RAC and hints are antifeatures.

modoc 6y ago
What DB has a better active-active HA cluster option than RAC? I love me some Postgres and MariaDB but I've never seen anything come close to RAC for making high volume queries against active-active just work.

castorp 6y ago

What's the difference between a query hint and a planner hint? > automatic planner adjustment when true cost was off More often than not, this "automatic adjustment" makes things worse. > active-active clustering with RAC But it's still shared storage, which doesn't really make it a true cluster in my opinion > out of the box backup tooling While this is true, there are several (free) backup tools that are easy to install and use and can rival rman's features.

aeyes 6y ago
A query hint is a clause you put into the query to make the planner execute the query in a certain way. Planner hint might not be the right term, Oracle has tools to show you different execution plans and to force a plan without touching the query on the application side. I'm not sure why shared storage would be a problem, the world runs on SANs and making them redundant is pretty much a solved problem. For running a RAC cluster you are required to have at least two network paths for each cluster node. Furthermore cluster communication is separated from storage communication.