News for hackers. Stuff that matters.
Re:Plans for partitioning in PostgreSQL v11 by qaq on Tuesday August 15, 2017 @08:33AM (#15017555)
The rate of evolution in PG is truly inspiring at this rate commercial RDBMS will not have much market left for them to play in.
Re:Plans for partitioning in PostgreSQL v11 by systems on Tuesday August 15, 2017 @11:27AM (#15019113)
if i take ms sql server for example it covers a lot more use cases out of the box compared to postgresql

ms sql is making significant progress for in memory optimization and in memory oltp .. i dont think postgres have any plans in this area

also ms sql, comes with ssis, ssrs and ssas, all under the same license you pay for ms sql server

ssas has no serious competition in the open source world and i would even argue it has no serious competition in the commercial world

the point is, commercial RDBMS comes packaged with a lot more than just the db engine .. postgresql will never compete with that

Re:Plans for partitioning in PostgreSQL v11 by riku_iki on Tuesday August 15, 2017 @01:43PM (#15020498)
> commercial RDBMS comes packaged with a lot more than just the db engine

It may be strength of psql and not weakness, they are focused on one specific niche, which actually covers 95% of business use cases, and trying to do it very well.

For all other cases, there are other products as well. Most of the data science world talks R and SQL now days, and not mdx.

Re:Plans for partitioning in PostgreSQL v11 by lobster_johnson on Tuesday August 15, 2017 @05:50PM (#15023001)
While Postgres is indeed fantastic, Oracle and Microsoft SQL Server are both ahead of Postgres in many areas. For example, the feature that this article is talking about — table partitioning — has been in Oracle for at least 20 years.

Oracle's replication support is also extensive, and supports many scenarios such as multimaster, not to mention sophisticated solutions such as RAC and Dataguard. Then there's materialized views, flashback queries, clustered tables (this is manual in Postgres), parallel queries, etc.

So Postgres is still mostly catching up to other databases. It still has features others don't, of course, such as transactional DDL statements. And it's open source.

Re:Plans for partitioning in PostgreSQL v11 by qaq on Tuesday August 15, 2017 @11:53PM (#15024837)
It's catching up fast which was the point :) if at present it's suitable for 85% (or whatever the proper estimate is) of use cases then at this rate it will reach 99% in not so distant future.
Re:Plans for partitioning in PostgreSQL v11 by lobster_johnson on Wednesday August 16, 2017 @01:00AM (#15025047)
I would say it's catching up extremely slowly, but that it's also way past the "sweet spot" where it's as good as the commercial offerings for the stuff people use databases for.
Re:Plans for partitioning in PostgreSQL v11 by rpedela on Wednesday August 16, 2017 @01:25AM (#15025139)
Postgres has materialized views.
Re:Plans for partitioning in PostgreSQL v11 by Thaxll on Tuesday August 15, 2017 @12:14PM (#15019537)
Well it's pretty much all about support and integration at some point, Postgres is like MySQL they have integration with open source app but nothing in the enterprise world.
Re:Plans for partitioning in PostgreSQL v11 by dfox on Tuesday August 15, 2017 @01:48PM (#15020534)
In my enterprise niche (logistics) it seems that PostgreSQL is the go to solution for essentially every new project (and surprisingly often is proposed by customers themselves).