Citus Cloud 2, Postgres, and Scaling Without Compromise

Re:Citus Cloud 2, Postgres, and Scaling Without Compromise by MuffinFlavored on Thursday November 16, 2017 @04:57PM (#15717056)

> * Performance improvements. Postgres 10 improves analytical query performance by 30-40%, and PG 11 will add another 3x. For Citus customers, they will get these performance benefits at scale.

When is that to be expected or even usable in beta?

[ Parent | on HN ]

Re:Citus Cloud 2, Postgres, and Scaling Without Compromise by manigandham on Thursday November 16, 2017 @05:14PM (#15717173)

Postgres 10 is out now, that's what's running when you start a new Citus Cloud cluster. Postgres 11 is in progress, you can always follow the official releases on the main site: https://www.postgresql.org

[ Parent | on HN ]

Re:Citus Cloud 2, Postgres, and Scaling Without Compromise by anarazel on Thursday November 16, 2017 @06:10PM (#15717557)

Please note that in both cases it obviously depends on where your bottleneck is. E.g. if you're IO bound, you're not going to see a lot of improvements. Similarly if most of your time is spent doing index scans there'll not be that much efficiency gains. Although in both cases parallelism can help.

If instead you're doing a bunch of aggregates over table, and the bottleneck is the computation of the transition values, computation of hashes, tuple deforming, etc... you might see quite some benefits (first two some in v10 already, all three hopefully in v11).

[ Parent | on HN ]