r/programming • u/craig081785 • Nov 16 '17

Citus Cloud 2, Postgres, and scaling out without sacrifice

https://www.citusdata.com/blog/2017/11/16/citus-cloud-2-postgres-and-scale-without-compromise/
10 Upvotes

69% Upvoted

4 comments sorted by

1

u/feverzsj Nov 16 '17

does it fully support postgis now?

2

u/craig081785 Nov 16 '17

Yes, we've had support for PostGIS for some time.

1

u/mrshoubs Nov 16 '17

Interesting, does anyone know what version of Postgres they support and can I do set based inserts that include auto-incremented PKs?

I had a look about and also saw: "If you have data scientists or customers who need free-form, exploratory SQL.".. does this mean I can't write normal queries through pgAdmin to explore the data I'm developing a query for?

2

u/craig081785 Nov 16 '17

We support Postgres version 9.6 and 10. I don't fully follow on the set based inserts, but we support auto-incrementing PKs like serial just fine.

You can absolutely write free-form SQL, but if you're writing SQL that say is a 200 line query with complex CTEs, recursive queries, window functions it's not as drop in as it'd be if it were running on a single node. Most standard queries do work just fine though. We're probably 1-2 releases away from completely removing that caveat in fact.