Hacker News new | comments | show | ask | jobs | submit login

Can you give a bullet point list aimed at someone who is very experienced at Postgres but has never used oracle? I'm curious of the corner cases and killer features that make you love oracle so much

I don't like Oracle DB really, but there's one feature that does stand apart from Postgres. Oracle has an internal scheduler that works much like an OS scheduler, allowing you to set priority and resource usage for each user or connection. This made Oracle the go-to database for anyone that needs multi tenant support but wants to allow users to access their own database. If you allow database access its trivial to create a really slow query and the resource limiters prevent one tenant from ruining performance for everybody.

The best example of this is Salesforce, which has their own proprietary SQL-like query language that's clearly just a crappy front end to generate raw SQL to feed their Oracle DB's. Without Oracle's per-tenant limit this would be far too risky because of idiots making bad queries.

An better solution these days is to put each tenant in a Postgres container and let the OS control resource limits for them, but this wasn't an option until recently.

Their own language prevents any kind of expensive queries. Besides that, they limit the amount of anything you can think of (queries, cpu time, memory, call, querytime).

Killing connections can be done in postgresql too. The reason for sf to be on oracle is probably history.

Is that feature available in Microsoft SQL Server?

Yes, there are resource controls in MS SQL server as well.

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)

One thing I can remember was the automatic query advisor.

It was actually good and very easy to activate. If you did activate it though you could expect a sizable extra invoice after next audit.

Guidelines | FAQ | Support | API | Security | Lists | Bookmarklet | DMCA | Apply to YC | Contact