My take aways:<p>* Reasons to migrate were: unresponsive support, inconvenient deployment, closed source, huge cost.<p>* It took just 10 man-years to rewrite whole project from Oracle to Postgres (e.g. 10 developers, 1 year), which is amazing.<p>* They benefited from Postgres data versioning, arrays and composite types.<p>* They liked writing logic on PL/pgSQL more than on Oracle PL/SQL: reduced code size, increased test coverage.<p>* Easier deployment of changes due no library cache locks.<p>Great thing for community is that Yandex now commited to Postgres, meaning it will get more testing and bug-fixes faster.
So having read through the slides, these are not bad slides, but I'm missing the 'real' wow-factor of why Postgres was a better choice in the end than Oracle. There's no doubt that the rewrite (which, because of PL/SQL -> PL/pgSQL, there was a rewrite) benefited them, but all I can glean from the slides is Postgres hasn't failed them yet and the rewrite worked.<p>So as much as I want to talk about Oracle vs. Postgres, these slides aren't giving me anything technical to debate.
I am using Yandex for my FOSS project's domain. So far, I haven't encountered any big issues. The web interface is plain and simple, but occasionally has some glitches.<p>Their mobile app (Android) is quite pleasant and lightweight.<p>What might be a problem for non-Russian speaking people is the lack of documentation in English. Quite often a random link redirects to a page in Russian.
To stay on topic: Does anyone else have stories of moving massive datasets to postgres from other commercial databases?<p>We're looking to make the switch from SQL Server when 9.6 comes out (and proves to be more scalable).
> 3x more hardware # for Postgres<p>Tells you something about how insanely costly Oracle's licenses are. Whatever you say about Oracle though - Oracle DB is an incredibly well performing and reliable piece of software. (Attested by experience - we had several Oracle DBs running on HP-UX Itanium that only needed to be handled when OS and Oracle patches were needed. Massively used too - think 36 PA-RISC cores at peak, 24 IA64 ones. It also helps that there are lot of DBAs with great deal of Oracle experience.)
This seems good.<p>Not related with the migration itself but I tried to use yandex and its mailing service a couple of years ago when attempting to become google independent but it didn´t work well with spanish queries so I eventually went back to google. But I recall that yandex mail was really nice.
I look at the operations of a lot of middle market tech companies that are fairly old (10+ years in existence) and I'm starting to see more and more companies move off of Oracle and on to Postgres. I expect this trend to continue.