Yandex.Mail's successful migration from Oracle to Postgres [pdf] • Hacker News Board

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

#51

Post by manigandham » Tue, Sep 13, 2016, 4:38 PM UTC

To stay on topic: Does anyone else have stories of moving massive datasets to postgres from other commercial databases?

We're looking to make the switch from SQL Server when 9.6 comes out (and proves to be more scalable).

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

#52

Post by oneloop » Tue, Sep 13, 2016, 4:39 PM UTC

alexro wrote: post #37

overcast wrote: post #7

Earlier quoted context omitted.

Please cite examples as to why it's your favorite Email provider.

You can set up your own domain for free

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

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

#53

Post by niftich » Tue, Sep 13, 2016, 4:40 PM UTC

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, these slides aren't giving me anything technical to debate.

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

#54

Post by nickpsecurity » Tue, Sep 13, 2016, 4:40 PM UTC

edge17 wrote: post #48

xienze wrote: post #47

Earlier quoted context omitted.

Russian email hosting. What could go wrong?

compared to what?

A place that wasn't a police state of sorts with increasingly draconian legislation. Opposite end would possibly be Swiss or Icelanfic jurisdiction. I'd never use an email service in Russia. I have an untrusted, Gmail account for availability purposes. Confidential mail still encrypted and preferrably sent through Swiss account.

Thinking about switching untrusted one over to Fastmail. Still surveillance state but less surveillance and supposedly good uptime.

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

#55

Post by ivan_gammel » Tue, Sep 13, 2016, 4:40 PM UTC

oneloop wrote: post #21

niftich wrote: post #17

Earlier quoted context omitted.

It technically means 'everything, whether necessary or not' [1][2], but the subtext and context I intended it in is that their range of services is forms an extremely wide spread, which could be mistaken for a lack of focus. [1] https://en.wiktionary.org/wiki/everything_but_the_kitchen_si... [2] http://dictionary.cambridge.org/us/dictionary/english/everyt...

Thanks. Yeah ok but you could say the same thing about google and they're doing well. You have yandex mail, web analytics, ads etc. How is that different from what google is going? In fact, I would say that yandex is trying to google's roadmap on how to conquer the world and see if they can pull it off in russia with the advantage that they currently have there.

Not really "trying Google roadmap", because in some areas (search, maps, mail) Yandex was first. They were not as successful, however, due to the focus on Russian market, management and technology specifics and business climate.

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

#56

Post by franole » Tue, Sep 13, 2016, 4:40 PM UTC

zuron7 wrote: post #44

Yandex.Mail provides custom domain E-Mails for free, the only large company to do so and not to mention how good it is.

Good tip. I recently did some research on email with free custom domain (well, really just googling and visit the first results) and did not know about them.

So for the moment I'm using zoho.com.

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

#57

Post by mablap » Tue, Sep 13, 2016, 4:41 PM UTC

xienze wrote: post #47

zuron7 wrote: post #44

Yandex.Mail provides custom domain E-Mails for free, the only large company to do so and not to mention how good it is.

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.

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

#58

Post by the_common_man » Tue, Sep 13, 2016, 4:41 PM UTC

LeonM wrote: post #50

xienze wrote: post #47

Earlier quoted context omitted.

Russian email hosting. What could go wrong?

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.

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

#59

Post by ivan_gammel » Tue, Sep 13, 2016, 4:43 PM UTC

pilsetnieks wrote: post #28

johansch wrote: post #18

Earlier quoted context omitted.

They moved most of their hosting to Amsterdam (and Stockholm?) 2-3 years ago, I heard. Since then the founder has been forced out by Putin, so I guess it might be back in Moscow now though. (Haven't really had any semi-inside information for the past year.)

It was the Vkontakte founder, Pavel Durov, that was forced out. Yandex hasn't had any notable public conflicts with the Putin regime.

Except that it had to sell it's "golden" share to state-owned Sberbank.

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

#60

Post by alexro » Tue, Sep 13, 2016, 4:43 PM UTC

oneloop wrote: post #52

alexro wrote: 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?

You can link your domain to the mail. And have unlimited number of inboxes.

https://pdd.yandex.ru/domains_add/

This is in Russian. Maybe there is English version