Live data from Hacker News

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

pgcon.org

181–190 of 222 posts

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

#181

Earlier quoted context omitted.

You don't need to look there, at all. Just look at the US aggressive wars and subversive activities in this century, e.g. Iraq, Libya and it becomes clear that the value of human rights abroad from the US point of view is exactly 0.

Iraq was a disgrace but bringing up Libya means you are either ignorant or being disingenuous. Gaddafi had imminent plans to commit another cleansing of the opposition. It was always going to be a lose-lose situation for human rights. Doing nothing is not always the right answer.

So how do you rate the situation in Libya before and after Gaddafi?

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

#183
post #179

Earlier quoted context omitted.

> 10 man-years are not though. Judging by the salaries from job sites and my yandex interview, the cost would most certainly top up at $0.5 million (that's a very generous guess, probably half or two thirds that, realistically). Not sure how much Oracle costs at Yandex scale (a LOT more?).

Am I missing something? How do you figure 10 man years = $500K ? Or is Yandex super stingy? DBAs and Developers worth their salt (who could pull off a multi-TB migration/etc without significant outage), would easily each go for $140K/yr minimum (so, 180-200K fully loaded with benefits and such). Still though: your point is valid in that, Oracle RAC cluster licensing and support is serious bucks.

Yes, you're missing the fact that it's Russia, not SV.

Couple of years ago ruble's exchange rates dropped significantly (it was ~33RUR for USD, now it's 64-65 rubles).

Monthly salaries for a good engineer in Moscow are usually 100-200k rubles, or 1.2-2.4M rubles/year.

It's only $18-36k per year. Looks insane from typical californian HR's point of view, isn't it?

Taxes take additional ~50% (in Russia, employer pays all the taxes and payments to the pension fund), so $500k was a pretty good estimate.

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

#184
post #65

Earlier quoted context omitted.

Postgres is free

10 man-years are not though. I'm a postgres fan and booster myself but I'd need a good reason to migrate a data backend on any project I'm managing.

I don't think you realize just how painfully expensive Oracle is. The reason they only went with an active/passive server layout vs. going active/active/active RAC is because they would've had to move to enterprise licensing. Then you're talking (at what I imagine their scale is) 7-8 figures a year.

http://www.oracle.com/us/corporate/contracts/processor-core-...

So if you look at just enterprise licensing, it's $47k per "processor" - which in their world, a single intel core counts as 0.5 processors. So if you've got a 36 core machine (which I think they mentioned in the video) that's 18 "processors". Or $846,000 for one box. You want clustering (RAC) - that's another $315,000. Partitioning? $207,000. So now we're up to ~$1.4 million for a single server. YAY!

Obviously these are list prices, so you should be paying less than that, but it gets ugly FAST.

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

#185
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,…

https://www.postgresql.org/message-id/CANNMO++6tPiwBv2OKcy-H...

oh, it was a pretty funny message. Official one! With huge amount of grammar errors in Russian text :-)

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

#186
post #65

Earlier quoted context omitted.

Postgres is free

10 man-years are not though. I'm a postgres fan and booster myself but I'd need a good reason to migrate a data backend on any project I'm managing.

it wouldn't have been 10 man years if they had less PL/SQL. I don't understand why people keep falling into that trap of putting complex logic in stored procedures.

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

#187
post #79

Earlier quoted context omitted.

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".

+ lobbying

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

#188

Earlier quoted context omitted.

I don't think you can lump Russia and China together. China is truly "on lower moral/ethical grounds". I can't trust any country that has such pervasive censorship policy and such blatantly protectionist policies as China. Frankly I trust the Russian government as much as I trust the US government or as much as I trust my government (the Mexican government). I don't think I would feel safe living in China! I wouldn't…

Russia is on a much lower ground ethically. China hasn't recently annexed territories from its neighbours whom they promised to protect and support just a few years ago.

Or helped shoot down a passenger jet...

Vladimir Putin is not our friend.

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

#189

Earlier quoted context omitted.

I don't think you can lump Russia and China together. China is truly "on lower moral/ethical grounds". I can't trust any country that has such pervasive censorship policy and such blatantly protectionist policies as China. Frankly I trust the Russian government as much as I trust the US government or as much as I trust my government (the Mexican government). I don't think I would feel safe living in China! I wouldn't…

Russia is on a much lower ground ethically. China hasn't recently annexed territories from its neighbours whom they promised to protect and support just a few years ago.

In this aspect there is really no differences between these 3 countries, China hasn't started a war like US, but using it's power to push boundaries in both west and east.
Post reply on HN