Live data from Hacker News

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

pgcon.org

81–90 of 222 posts

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

#81
post #60
post #52

Earlier quoted context omitted.

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

There is. https://domain.yandex.com/domains_add/

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

#82
post #60
post #52

Earlier quoted context omitted.

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

не надо, спасибо огромный за сылку

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

#83
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.

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 even travel to China but that's just me.

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

#84
post #23

Earlier quoted context omitted.

Let's talk Oracle vs Postgres rather than USA vs Russia

So - as a long time Oracle DBA (who also loves Postgres), I've been seeing a lot of companies do this sort of move. There are a couple of downsides, but really - there's a lot more upsides to Postgres than downsides (IMO).

I'd love to hear more detail. We hear a lot from the PostgreSQL team and its fans (amongst whom i count myself!), but a lot less from people on the Oracle side.

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

#85
post #60
post #52

Earlier quoted context omitted.

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

https://pdd.yandex.com/domains_add/

Just replace .ru with .com and everything else is the same, except the language.

I just registered and yandex mail really seems like a fine service.

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

#86

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

I'd also look into Citus (PG plugin for scaling)

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

#87
post #80
post #70

Earlier quoted context omitted.

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…

Details were in the talk itself, watch the video https://www.youtube.com/watch?v=-SS4R1sFH3c. In particular, they mentioned how Tom Lane fixed a bug they found and did it just in 38 minutes.

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

#88

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

SQL Server performs slightly better than PostgreSQL for analytics. This is mostly because of parallel queries which will still be more efficient on SQL Server when PostgreSQL 9.6 is released.

On the other hand, PostgreSQL can take advantage of ZFS compression which is great for archiving cold data.

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

#89
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.

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

#90
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...
Post reply on HN