[patates]

Do you plan to write more about the migration, like a blog post? That would be very interesting to read.

[unixhero]

This needs to become a thing. Where people produce writeups on Oracle To Postgres, and how much better it is; under something like #RunsMuchBetterWithPostgres ...

It is strange that there aren't more writeups on Postgresql migrations.

Yandex had a good one. Posted here a long while ago: https://news.ycombinator.com/item?id=12489055

[KingMob]

> It is strange that there aren't more writeups on Postgresql migrations.

It's probably because switching databases is very painful and rare.

[unixhero]

I would think that not having to pay the Oracle/MS/Sybase/Teradata licenses are a good enough incentive...

Speaking of economic incentives.

That could be a thesis topic for my hereto unwritten PhD in Behavioral Economics:

"Choosing to pay" What are the behavioral aspects of top leadership - Why do people still chose proprietary" A quantitative case study."

[Ygg2]

If I had to wager, it's support. Oracle/MS generally provide much better support that open source software.

[jeltz]

Oracle is definitely not known for their good support, and there are plenty of companies which provide really good PostgreSQL support.

[irrational]

This. It was worth it, but it still took us the better part of a year.

[sharninder]

Another one here:

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

[irrational]

It would take a lot more than a single blog post. It would probably take dozens of blog posts (or a book). It took us the better part of a year. There are just so many things that have to be taken into consideration and learned.

[thorin]

I'd be very interested in this after years of working with Oracle (and SQLServer), I know a little Postgres and would like to learn more.

[gigatexal]

+1 to this.