Just from reading the documentation, the full text search features on Postgres already look pretty powerful. And it is encouraging that they are actively being worked on. I'm wondering how this compares to a dedicated search engine like Solr or Elasticsearch.<p>Are there huge differences in performance, features or search quality? At which scale does using Postgres for full text search still make sense?
Please can the Postgres team put some major focus on completing logical replication [1]. It's the missing piece to making upgrading across major versions painless and quick on large databases so that we can take advantage of all these nice new features. We're on a Heroku's hosted Postgres service so can't install the pglogical extension.<p>1. <a href="http://blog.2ndquadrant.com/why-logical-replication/" rel="nofollow">http://blog.2ndquadrant.com/why-logical-replication/</a>
A tangential question:<p>Everyone speaks about InnoDB and how performant and reliable it is... and multiple firms even use it as a KV-store (Uber/Pinterest/AWS) bypassing MySQL entirely. I have never heard much about storage engines in Postgres, why could this be so?<p>Wikipedia has a (stub) article on InnoDB, but nothing on Postgres' storage engines... just wondering why that is.
> Index-only scans for partial indexes<p>This one is huge for my company. Almost every single query of ours could use an index-only scan, but the planner would never choose to perform one because of the weirdness around partial indexes. We expecting a several x speedup once we upgrade to 9.6. All the need to improve now is a way to keep the visibility map up to date without relying on vacuums.
Congratulations to the PostgreSQL Global Development Group on a much-anticipated release.<p>Curious about this:<p>> parallelism can speed up big data queries by as much as 32 times faster<p>Why would it be only 32 times faster? The sky's the limit if there aren't major bottlenecks on the way.
Congrats on great release. With availability of E7-8800 v4 based servers (up to 192 cores in a single box) PG can cover a huge number of use cases without complicated setups.
Anyone know the state of BDR in 9.6?<p><a href="http://blog.2ndquadrant.com/bdr-is-coming-to-postgresql-9-6/" rel="nofollow">http://blog.2ndquadrant.com/bdr-is-coming-to-postgresql-9-6/</a>