4 ms·
SQL doesn't work well in a distributed setup. Give up on SQL and it gets easier. The most popular hack for PostgreSQL is citusdb https://www.citusdata.com/ htt
by user5994461 10y ago
SQL doesn't work well in a distributed setup. Give up on SQL and it gets easier.
The most popular hack for PostgreSQL is citusdb https://www.citusdata.com/ https://www.citusdata.com/ , of course it comes with many limitations and drops half of SQL
- kod 10y agoThat's FUD, citus doesn't "drop half of sql". Anything that can be resolved to a single node works exactly like normal postgres, and the main multinode things you want (e.g. aggregations) work transparently. The actual limitations are usually easy to work around. https://docs.citusdata.com/en/v6.1/reference/sql_workarounds.html https://docs.citusdata.com/en/v6.1/reference/sql_workarounds...
- user5994461 10y agoI guess they improved significantly since my last work around it.