4 ms·

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.

• systems 9y ago
  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
  • riku_iki 9y ago
    > 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.
• Thaxll 9y ago
  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.
  • dfox 9y ago
    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).
• lobster_johnson 9y ago
  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.
  • qaq 9y ago
    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.
    • lobster_johnson 9y ago
      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.
  • rpedela 9y ago
    Postgres has materialized views.