Re:New in PostgreSQL 10
by patates on Friday September 22, 2017 @02:58AM
(#15309957)
Do you plan to write more about the migration, like a blog post? That would be very interesting to read.
[ Parent
| on HN ]
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
> It is strange that there aren't more writeups on Postgresql migrations.
It's probably because switching databases is very painful and rare.
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."
If I had to wager, it's support. Oracle/MS generally provide much better support that open source software.
Oracle is definitely not known for their good support, and there are plenty of companies which provide really good PostgreSQL support.
Re:New in PostgreSQL 10
by irrational on Friday September 22, 2017 @01:02PM
(#15313886)
This. It was worth it, but it still took us the better part of a year.
Re:New in PostgreSQL 10
by sharninder on Friday September 22, 2017 @05:05AM
(#15310423)
Another one here:
Re:New in PostgreSQL 10
by irrational on Friday September 22, 2017 @01:06PM
(#15313916)
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.
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.