Live data from Hacker News

Yandex.Mail's successful migration from Oracle to Postgres [pdf]

pgcon.org

71–80 of 222 posts

Re: Yandex.Mail's successful migration from Oracle to Postgres [pdf]

#71
post #49

Earlier quoted context omitted.

But how about the bribes (to get e.g. electricity)? http://www.nytimes.com/2009/09/12/business/global/12ikea.htm...

Yandex is a public company with stocks on NASDAQ. Can you ever imagine how it is hard to hide bribes inside of public company budget? :)

Two words: "consultancy services"

Re: Yandex.Mail's successful migration from Oracle to Postgres [pdf]

#72
post #49

Earlier quoted context omitted.

But how about the bribes (to get e.g. electricity)? http://www.nytimes.com/2009/09/12/business/global/12ikea.htm...

Yandex is a public company with stocks on NASDAQ. Can you ever imagine how it is hard to hide bribes inside of public company budget? :)

Just give someone a big performance bonus with the understanding that part of it is to be used on bribes? Seems rather easy.

Re: Yandex.Mail's successful migration from Oracle to Postgres [pdf]

#73
post #50

Earlier quoted context omitted.

American email hosting, what could go wrong?

Yeah, I always find it amusing when people find russia and china on a lower moral/ethical ground when everything on american soil is equally watched and processed. if not by nsa, it's for ads.

Please take a look at the Human Rights Watch reports[0] for USA, China and Russia. I honestly wonder how you can reach such a conclusion about freedom of expression and human rights in those countries.

[0] https://www.hrw.org/world-report/2016

Re: Yandex.Mail's successful migration from Oracle to Postgres [pdf]

#74
post #52
post #37

Earlier quoted context omitted.

You can set up your own domain for free

Go on. They give you a domain? I never saw that... Link please?

I think they mean you can have email on a custom domain for free. Not that they give custom domains for free.

Re: Yandex.Mail's successful migration from Oracle to Postgres [pdf]

#75
post #53

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. So as much as I want to talk about Oracle vs. Postgres,…

> but I'm missing the 'real' wow-factor of why Postgres was a better choice in the end than Oracle

I'm guessing it was a few million dollars worth of wow-factor.

Re: Yandex.Mail's successful migration from Oracle to Postgres [pdf]

#76
post #57
post #47

Earlier quoted context omitted.

Russian email hosting. What could go wrong?

If you use PGP it doesn't matter where you host, right? If you're concerned about local officials having access to your data I don't think it's much worse than Google scanning my email to better target ads or "just to remind me" that I'm going at X or Y place in Z days.

From a purely technical and tinfoil-hat point of view, they'd have meta-data about your emailing habits. They wouldn't be able to read the mail for your encrypted traffic, but lets be honest - most people don't. So that mail could be read too.

Re: Yandex.Mail's successful migration from Oracle to Postgres [pdf]

#77
post #53

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. So as much as I want to talk about Oracle vs. Postgres,…

> I'm missing the 'real' wow-factor of why Postgres was a better choice in the end than Oracle

Not having to deal with stuff like this while having the same features/performance/stability/etc may qualify as a 'wow':

http://www.orafaq.com/wiki/Oracle_licensing

Re: Yandex.Mail's successful migration from Oracle to Postgres [pdf]

#78

Earlier quoted context omitted.

Yeah, I always find it amusing when people find russia and china on a lower moral/ethical ground when everything on american soil is equally watched and processed. if not by nsa, it's for ads.

Asking seriously, but isn't Russia fundamentally closer to a kleptocracy? Dishonesty is apparently more pervasive and built in to their culture. From my understanding, bribe culture and cheating are an accepted norm. Not to say these characteristics do not exist in America, just not anywhere to the same extent?

>> Dishonesty is apparently more pervasive and built in to their culture.

Oh yeah [smiles dishonestly from across the ocean]

Re: Yandex.Mail's successful migration from Oracle to Postgres [pdf]

#79

Earlier quoted context omitted.

Yeah, I always find it amusing when people find russia and china on a lower moral/ethical ground when everything on american soil is equally watched and processed. if not by nsa, it's for ads.

Asking seriously, but isn't Russia fundamentally closer to a kleptocracy? Dishonesty is apparently more pervasive and built in to their culture. From my understanding, bribe culture and cheating are an accepted norm. Not to say these characteristics do not exist in America, just not anywhere to the same extent?

The US just uses different words, such as "campaign financing", or "creative accounting".

Re: Yandex.Mail's successful migration from Oracle to Postgres [pdf]

#80
post #70
post #53

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. So as much as I want to talk about Oracle vs. Postgres,…

1. Price if obvious reason of migration, and in their case (multiple datacenters and "-1 datacenter" policy) it was huge benefit. 2. The other concern was Oracle's slow bugfixing and reaction to feedback. So, this is a good case showing how a company can stop wasting millions of $ for proprietary software, joining Open Source community, contributing to it and taking benefits from tech collaboration with core develope…

So, they say 'shop.oracle.com' was their 'main reason' for switching but that reads as a half-joke, half-serious riff on Oracle's famous ability to extract money from people; the other salient points I can find are:

- PL/SQL was harder to deploy than PL/pgSQL (as stated later)

- Only synchronous interface in Oracle's OCCI

- Problems with Oracle's development environments

- Not very responsive support from Oracle.

But the dev environment and support for Postgres are not talked about.

Also I can't quite figure out if "3x more hardware" is supposed to be a good thing on their last slide. It's possible that it's a good thing (if it's, say, we can replicate to more servers), but to me it doesn't read like one.

Post reply on HN