How does PostgreSQL 10 compare with Cassandra for BigData requirements?
Define "big data"? You can buy normal tier 1 server vendor hardware with 6T of memory. If it fits into 1 machine or a few, it isn't "big data".
[deleted]
New in PostgreSQL 10
11–20 of 258 posts
Re: New in PostgreSQL 10
#12Just...wow. * Native partitioning * Parallel query Honestly, some very welcome quality of life improvements for use cases even outside of what I would consider "Big Data". > This means that users no longer need to create triggers for routing data; it's all handled by the system. Trigger routing has always been a performance foot gun...to the point that it's sometimes better to handle table routing in application logi…
Parallel query was already there in 9.6 though this release improves on it further.
Re: New in PostgreSQL 10
#13Re: New in PostgreSQL 10
#14SCRAM authentication looks like a nice security improvement also. No description on the site but http://paquier.xyz/postgresql-2/postgres-10-scram-authentica... gives a good overview.
It's an improvement for sure, but I am curious -- does anyone situate a Postgres instance where it is publicly accessible? Who was asking for this feature?
Re: New in PostgreSQL 10
#15Just...wow. * Native partitioning * Parallel query Honestly, some very welcome quality of life improvements for use cases even outside of what I would consider "Big Data". > This means that users no longer need to create triggers for routing data; it's all handled by the system. Trigger routing has always been a performance foot gun...to the point that it's sometimes better to handle table routing in application logi…
Parallel query was already there in 9.6 though this release improves on it further.
It makes parallel query much more useful. There were very few places that parallel query helped with my workload in 9.6, that is not true for 10.
Re: New in PostgreSQL 10
#16SCRAM authentication looks like a nice security improvement also. No description on the site but http://paquier.xyz/postgresql-2/postgres-10-scram-authentica... gives a good overview.
It's an improvement for sure, but I am curious -- does anyone situate a Postgres instance where it is publicly accessible? Who was asking for this feature?
Lots of cloud managed dbs are/can be publicly accessible. Eg all heroku hosted Postgres instances
Re: New in PostgreSQL 10
#17How does PostgreSQL 10 compare with Cassandra for BigData requirements?
Does Cassandra allow aggregate functions like sum() or avg() yet?
Re: New in PostgreSQL 10
#18Earlier quoted context omitted.
Define "big data"? You can buy normal tier 1 server vendor hardware with 6T of memory. If it fits into 1 machine or a few, it isn't "big data".
And the postgres maximum table size is 32T.
You can partition your table if it got anywhere near that large (with the shiny native partitioning introduced in PostgreSQL 10).
Re: New in PostgreSQL 10
#19If anyone even remotely involved with the maintenance and development of pg reads this thread - Thank you! - for all your efforts in building and improving a first class product that keeps me amazed at the strides it takes with each major. release.
Re: New in PostgreSQL 10
#20Earlier quoted context omitted.
Define "big data"? You can buy normal tier 1 server vendor hardware with 6T of memory. If it fits into 1 machine or a few, it isn't "big data".
And the postgres maximum table size is 32T.
You really don't want to have the whole DB be much above 30TB. You'd either want to shard or use some alternative solution.