Comment

Comment by aeyes

- 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.

parent aeyes 6 years ago

Discussion

Live from the official Hacker News API

A modern reader for Hacker News · SvelteKit + Skeleton