4 ms·
My take aways: * Reasons to migrate were: unresponsive support, inconvenient deployment, closed source, huge cost. * It took just 10 man-years to rewrite whol
by coolspot 10y ago
My take aways:
* Reasons to migrate were: unresponsive support, inconvenient deployment, closed source, huge cost.
* It took just 10 man-years to rewrite whole project from Oracle to Postgres (e.g. 10 developers, 1 year), which is amazing.
* They benefited from Postgres data versioning, arrays and composite types.
* They liked writing logic on PL/pgSQL more than on Oracle PL/SQL: reduced code size, increased test coverage.
* Easier deployment of changes due no library cache locks.
Great thing for community is that Yandex now commited to Postgres, meaning it will get more testing and bug-fixes faster.
- anarazel 10y ago> Great thing for community is that Yandex now commited to Postgres, meaning it will get more testing and bug-fixes faster. That remains to be seen. There's a fair amount of huge postgres users that don't even bother to report bugs they find...
- postila 10y agoIt's already seen during couple of years – google author's name on postgresql.org (maillists archives)
- postila 10y agoBut you're right – a lot of such companies exist unfortunately. If Uber DBAs came to IRC or any public place (see http://Postgres.chat http://Postgres.chat) where Postgres experts are present and didn't hesitate asking questions, they would still be running Postgres.
- plorkyeran 10y agoYandex has a pretty good track record for contributing back to open source projects they use (and open-sourcing their own technologies).
- Spearchucker 10y agoI have no love for Oracle (at all, actually), but let's not kick the donkey when it's down. Having been through tech refreshes myself I'll bet most of those benefits would've been realized, regardless of data provider. Too much opportunity for a competent team to reduce or eliminate technical debt.
- microcolonel 10y agoPeople are still buying Oracle licenses, we have to kick it until it's dead.