2 ms·
Right, but even with the added complexity (not that much for something like Postgres-XL), you still end up with all the benefits of a robust and performant rela
by yellowapple 8y ago
Right, but even with the added complexity (not that much for something like Postgres-XL), you still end up with all the benefits of a robust and performant relational database.
Meanwhile, for the FDW-based DIY approach, it should be at least theoretically (if not practically) possible to support both transactions and predicate pushdowns, especially if the foreign database is another Postgres database (or SQL at all, for that matter).
More to the point, though: the idea is that you shouldn't have to prematurely optimize. The vast majority of websites don't need a full-blown distributed database. In the rare event that your site grows to that point, it ain't really all that difficult to switch to Postgres-XL or CockroachDB or something that gets you the best of both worlds.