Live data from Hacker News

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

pgcon.org

201–210 of 222 posts

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

#201
post #47
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?

I worked for Yandex. AMA. Will not violate NDA, obviously.

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

#202
post #113

Earlier quoted context omitted.

What about a country which has one forth of the China population which has institutional rules about the police being able to seize the money you carry, your money on cards you carry and your car without even charging you with an offense, where 6% of the black population is in jail, and 1% of the total population, and where you can be routinely shot dead if you are mentally disabled or if you play poker at home or ac…

Routinely shot dead if you are mentally disabled or playing poker ? You completely invalidate any point you had when you resort to ridiculous hyperbole.

http://www.dailymail.co.uk/video/news/video-1168142/GRAPHIC-...

http://abc7.com/news/video-shows-unarmed-mentally-ill-man-sh...

https://www.youtube.com/watch?v=W-WjXLZbJnU

https://www.youtube.com/watch?v=KOwRMq_Fg5w

http://www.dailymail.co.uk/news/article-2515428/Police-shoot...

> seen by their willingness to bet and lose large amounts of money to take down sports bookies

https://www.washingtonpost.com/news/local/wp/2015/01/27/fair...

http://www.washingtonpost.com/wp-dyn/content/article/2006/01...

http://www.cardplayer.com/poker-news/18352-poker-players-tak...

https://www.pokertube.com/poker-news/poker-gossip-opinion/sw...

http://www.salon.com/2013/07/07/%E2%80%9Cwhy_did_you_shoot_m...

I can't find the highly graphic one about the one who got shot, like, 18 times, while was unarmed in front of a shop. Anyway poker shooting is a reality: It's illegal gambling, therefore it's considered high-level criminality.

Not to judge who's right or wrong, who's "supposed to know" and who's at risk - I'm only saying the risk of being shot dead by the USA police is immensely higher than in any other country in the world, including Russia and China.

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

#203
post #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.

Minor note: ZFS compression is great for live data too -- lz4 compression has very low CPU overhead.

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

#206
post #110

Earlier quoted context omitted.

You can check it on sec.gov. Yandex spend nothing on consultancy for 2014 and 2015 years

I can't be bothered to dig right now, but you're saying that a company with 5000+ employees did not use any consultants at all, zero, for 2014 and 2015? I really can't believe that. Edit: there are many ways to hide bribes, of course. Typically it involves overpaying for something. It would be hard for even a non-corrupt tax authority to tell the difference between having bad negotiation skills and bribes.

My point is "big non-government companies in Russia doesn't pay any bribes". But you're right, it's definitely possible do hide some amount of bribe money if you really want to.

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

#207
post #112

Earlier quoted context omitted.

Nope, both salaries and bonuses (even on C level) is too low in Russia to hide any amount of bribe in them. Anyway, I never heard about bribes for electricity for last 5 years in Russia.

> salaries and bonuses (even on C level) is too low in Russia to hide any amount of bribe in them Let's say someone claims that their programmer genius Ivan saved a company ~1m USD/year with latest commit; and awards him $100k. And you see this unusual bonus, how are you going to know 99% of that doesn't go to someone other than Ivan?

Typical Ivan with good developer skills costs $30k/year in Moscow. But you are right, theoretically it is possible to hide some money if you really wants to. As far as I know there's no big non-gov companies who spend something on bribes right now. May be it's because I too believe in humankind.

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

#208
post #201
post #47

Earlier quoted context omitted.

Russian email hosting. What could go wrong?

I worked for Yandex. AMA. Will not violate NDA, obviously.

Are you able to say anything about the scale of their hardware? It says "3x hardware" but I'd love to hear how big that ends up being, at either the Oracle or Postgresql size.

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

#209
post #199

> 3x more hardware # for Postgres 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…

Nobody argues that Oracle is a very good database. But 3x more hardware and 10 man-years are an order of magnitude cheaper than Oracle licencies cost (even with maximum discount).

Yes that's the point I was trying to make. Licenses and support are an ongoing cost and from what I keep hearing oracle has increased them significantly in recent years.
Post reply on HN