New in PostgreSQL 10

Re:New in PostgreSQL 10 by irrational on Thursday September 21, 2017 @11:45PM (#15309256)

Truly. We've recently moved from Oracle (after using it for 15 years) to Postgresql. It's like a breath of fresh air. The documentation for Postgres is unbelievably superior to Oracle. So far its performance is equal to or better than Oracle. We had to go through and rewrite thousands of queries, but the sql syntax of Postgres was always simpler and more logical than the equivalent in Oracle (I think Oracle has too much baggage from being around too long). All in all I'm so impressed by Postgres. I'm sure there are features in Oracle that Postgres doesn't have that keep people on Oracle, but I would imagine that the vast majority of Oracle installs could be moved to Postgres.

[ Parent | on HN ]

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 ]

Re:New in PostgreSQL 10 by unixhero on Friday September 22, 2017 @04:36AM (#15310324)

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

[ Parent | on HN ]

Re:New in PostgreSQL 10 by KingMob on Friday September 22, 2017 @09:18AM (#15311861)

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

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

[ Parent | on HN ]

Re:New in PostgreSQL 10 by unixhero on Friday September 22, 2017 @12:12PM (#15313420)

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

[ Parent | on HN ]

Re:New in PostgreSQL 10 by Ygg2 on Friday September 22, 2017 @12:38PM (#15313687)

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

[ Parent | on HN ]

Re:New in PostgreSQL 10 by jeltz on Friday September 22, 2017 @08:19PM (#15317187)

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

[ Parent | on HN ]

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.

[ Parent | on HN ]

Re:New in PostgreSQL 10 by sharninder on Friday September 22, 2017 @05:05AM (#15310423)

Another one here:

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

[ Parent | on HN ]

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.

[ Parent | on HN ]

Re:New in PostgreSQL 10 by thorin on Friday September 22, 2017 @05:05AM (#15310429)

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.

[ Parent | on HN ]

Re:New in PostgreSQL 10 by gigatexal on Friday September 22, 2017 @02:45PM (#15314679)

+1 to this.

[ Parent | on HN ]

Re:New in PostgreSQL 10 by kochthesecond on Friday September 22, 2017 @05:27AM (#15310500)

I think most Oracle installs are from the days ram was limited and incredibly expensive.

Right now anyone can afford a db server with 128gb ram, enough to solve most problems #YourDataFitsInRam

[ Parent | on HN ]

Re:New in PostgreSQL 10 by wiz21c on Friday September 22, 2017 @10:19AM (#15312371)

>> I think most Oracle installs are from the days ram was limited

Could you explain ?

Personally I use Oracle (and hopefully one day PG) because it gives me guarantees on data integrity and these guarantees help me to think about my programs more easily.

[ Parent | on HN ]

Re:New in PostgreSQL 10 by dsr_ on Friday September 22, 2017 @01:31PM (#15314097)

Oracle started before microcomputers (PCs) were anything but toys. In 1983, they were multiplatform: mainframes and minicomputers. a 1983 minicomputer might have 2 CPUs, each good for 2 MIPS, 8 MB of RAM and primary storage of as much as a gigabyte or two of disks.

In the early 2000s, a serious database machine -- say, a Sun E10000 - had up to 64 CPUs, running at 400-500MHz each, 64 GB of RAM, and a huge cabinet full of disks.

Now you can call up a SuperMicro VAR and order a 64-core AMD EPYC server with 2TB of RAM and 4 TB of NVMe drives, that talks to other machines over a 100Gb/s ethernet, for a price around the same as a used Tesla S85.

If your database is under 2TB, it all fits in RAM on commodity hardware, where commodity is defined as "anyone with a credit card can order it without even talking to sales".

[ Parent | on HN ]

Re:New in PostgreSQL 10 by wiz21c on Saturday September 23, 2017 @08:22AM (#15319418)

>>> Oracle started before microcomputers (PCs) were anything but toys.

I didn't know that. At that time I was discovering Applesoft basic :-)

[ Parent | on HN ]

Re:New in PostgreSQL 10 by type0 on Monday September 25, 2017 @04:34AM (#15328823)

Oracle is the real elephant in the room, all pun intended.

[ Parent | on HN ]