PostgreSQL 10 Beta 1 Released
postgresql.org
PostgreSQL 10 Beta 1 Released
1–10 of 172 posts
Re: PostgreSQL 10 Beta 1 Released
#2Important features:
Native Table Partitioning - https://www.keithf4.com/postgresql-10-built-in-partitioning/ Logical Replication - https://blog.2ndquadrant.com/logical-replication-postgresql-...
or what is new in PG 10 https://wiki.postgresql.org/wiki/New_in_postgres_10
Postgresql really awesome!
Re: PostgreSQL 10 Beta 1 Released
#3Congratulations to the team. The replication/partition improvements are significant and much appreciated.
My favorite improvements are full text search of JSON & JSONB; this makes pg a full replacement for Mongo for my use cases.
Re: PostgreSQL 10 Beta 1 Released
#4The new features related to clustering looks exciting. Also SCRAM support and Full text search for JSON and JSONB . Postgres is cementing itself as not only the safe choice for Databases but also the Swiss Army knife .
Re: PostgreSQL 10 Beta 1 Released
#5The native table partitioning makes me so happy. I'd been doing this for years with really hacky external modules and tons of triggers. Sadly, even then there were always weird edge cases.
Postgres really has become the most versatile database out there. I cringe whenever I have to work with MySQL again...
Re: PostgreSQL 10 Beta 1 Released
#6I wished they would implement more from SQL:2011. I have a lot of applications that would benefit from system versioned tables.
This is a good sum up of useful modern SQL features: https://www.slideshare.net/MarkusWinand/modern-sql
Re: PostgreSQL 10 Beta 1 Released
#7As someone with little to no Postgres experience, it seems like they are heading in the direction of providing the type of massively parallel, scale out features that Citus provides.
Would love to hear thoughts from someone with real expertise.
Re: PostgreSQL 10 Beta 1 Released
#8As someone with little to no Postgres experience, it seems like they are heading in the direction of providing the type of massively parallel, scale out features that Citus provides. Would love to hear thoughts from someone with real expertise.
Citus is building functionality on PostgreSQL to provide sharding for data sets too large for a single machine. There aren't really any PG 10 features that duplicate that. Some of the new PG features such as increased query parallelism allow for better utilization of single-machine resources. Other features such as logical replication may allow for some horizontal scaling by splitting read workloads across replicas, but none of them provide any sharding capabilities.
Re: PostgreSQL 10 Beta 1 Released
#9As someone with little to no Postgres experience, it seems like they are heading in the direction of providing the type of massively parallel, scale out features that Citus provides. Would love to hear thoughts from someone with real expertise.
Citus is building functionality on PostgreSQL to provide sharding for data sets too large for a single machine. There aren't really any PG 10 features that duplicate that. Some of the new PG features such as increased query parallelism allow for better utilization of single-machine resources. Other features such as logical replication may allow for some horizontal scaling by splitting read workloads across replicas,…
Aggregate push down to foreign servers seems to overlap with Citus. It's not as transparent, but you could have a dataset sharded across several PG instances, mount them all into a master with foreign data wrappers, and UNION them (for some queries) to aggregate across the set.
Re: PostgreSQL 10 Beta 1 Released
#10Congratulations to the team. The replication/partition improvements are significant and much appreciated. My favorite improvements are full text search of JSON & JSONB; this makes pg a full replacement for Mongo for my use cases.
I feel like this feature replaces almost all of Mongo's use cases!