Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

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

pgcon.org

Post reply on HN
Print view View original

151–160 of 222 posts

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

#151

Post by _0w8t »

johansch wrote: post #43
bobuk wrote: post #38

Earlier quoted context omitted.

Oh no, at least not now. Electricity and land so cheap today in Russia, what Yandex starts to build and sell their datacenter to provide "cheap AWS alternative for Russian companies".

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

Bribes for infrastructure is not how modern days high level corruption works in Russia. What happens is that for various preferences that a company receives from the state like tax rebates, cheaper electricity etc. one pays back to the official who authorized the deal. The payment (otkat or "rollback" in Russian) is typically indirect, like using a supplier or outsourcing to a company where the official or their relatives have a stake.

The direct bribes is really for low-level clerks like police officers or fire hazard inspector s.

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

#152

Post by microcolonel »

Spearchucker wrote: post #115
coolspot wrote: post #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 cov…

I have no love for Oracle (at all, actually), but let's not kick the donkey when it's down. Having been through tech refreshes myself I'll bet most of those benefits would've been realized, regardless of data provider. Too much opportunity for a competent team to reduce or eliminate technical debt.

People are still buying Oracle licenses, we have to kick it until it's dead.

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

#153

Post by y4mi »

joesmo wrote: post #122
rjeli wrote: post #73

Earlier quoted context omitted.

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

The parent is talking only about surveillance, but from the report you linked, it's pretty obvious the US, Russia, and China, are pretty much in the same horrific boat as far as human rights abuses. Actually, I'd say the US, with 2.37 million people behind bars is worse than either China or Russia or any other country currently on earth. When you're systematically ruining that many lives, you're in Nazi territory.

i hope you're kidding or trolling.

the current situation with incarcerations in america sounds horrible, yes, but its a far cry from systematically eradicating millions of people per year...

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

#154

Post by [deleted] »

healthnutter wrote: post #68
the_common_man wrote: post #58

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?

[deleted]

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

#155

Post by kofejnik »

jorgecastillo wrote: post #83
the_common_man wrote: post #58

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.

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.

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

#156

Post by greggyb »

olavgg wrote: post #88
manigandham wrote: post #51

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.

SQL Server also comes with SSAS, if we're talking analytics. There's the very mature MDX-based Multidimensional mode, and a heavily optimized columnstore engine with the DAX-based Tabular mode.

For analytical workloads, SQL is often a poor choice.

Full disclosure, I work for an analytics and BI Microsoft partner. There are plenty of great alternative semantic layers beyond SSAS, but I am not as comfortable with each of those.

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

#157

Post by oneloop »

PerfectDlite wrote: post #147
oneloop wrote: post #33

Earlier quoted context omitted.

> Another aspect of the service I really like, is that it has less magic than Gmail. I always get email labeled wrong in Gmail. At first I tried to label them properly and expected Google to get them right over time, now I don't bother. While I never tried yandex's email, I do share the impression that gmail is too magical and shouldn't be labelling my emails outside of the explicitly rules that i have set. > To be f…

> Those two countries are similar in so many ways. Like invading and annexing their neighbours?

Exactly. Although to be fair to the US, their military is quite a bit more powerful, so they've already pacified their neighbours and instead invade countries half way around the globe. Russia can't stretch itself as much. But yeah, same principle.

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

#158

Post by ansgri »

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?

Mail delivery delays can get huge, that's what's wrong with Yandex. Mail routinely takes 10-20 minutes to arrive.

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

#159

Post by deepwave »

nickpsecurity wrote: post #54
edge17 wrote: post #48

Earlier quoted context omitted.

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 les…

Fastmail has been my go-to for almost as long as they have existed--almost 15 years. There is NOTHING better in my estimation and I've used them all before--free and paid.

Rob and the Fastmail team are most likely the best in the world at what they do, and as an IT guy with decades of experience, I don't say that lightly. They have more than earned my shekels every year. Give them a go... you will be very pleasantly surprised.

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

#160

Post by blacksmith_tb »

homero wrote: post #140
xienze wrote: post #47

Earlier quoted context omitted.

Russian email hosting. What could go wrong?

I actually like it, sure they read it but they can't get me and they won't allow usa snooping. I use it a lot

I feel the same way about Chinese IoT vendors - the cheap Xiaomi 'Little Ants' webcam that watches packages get dropped off on my front porch is routing notifications (and video, on demand - it stores stuff locally on an mSD) to servers in China, but it seems extremely unlikely that the PRC government has any interest in it, or use for it; and I doubt Xiaomi would bother giving it up to any other government.
Post reply on HN