Re:Why Use Postgres?
by AlisdairO on Sunday April 30, 2017 @04:13PM
(#14233579)
Disclaimer: huge postgresql fanboy, use it whenever I get the chance
A few things I've found great in Oracle that aren't (AFAIK) available in PG:
- Straight better/more reliable performance on average
- More advanced parallel queries (obviously this is changing in PG right now)
- Flashback queries
- Better materialized views
- Plan stability (maintains predictable query performance, rather than the nasty jumps you sometimes see when plans change)
- Better clustering story (RAC is super expensive but pretty good)
A few things I've found great in Oracle that aren't (AFAIK) available in PG: