3 ms·
What would be great is some way to codify all this advice. Eg run PG in a Data Warehouse mode. Databases are too big and too configurable and without specialist
by u678u 5y ago
What would be great is some way to codify all this advice. Eg run PG in a Data Warehouse mode. Databases are too big and too configurable and without specialist DBAs any more most people are just guessing what works best.
- cedricd 5y agoThat's a great point. This isn't really what you're saying, but citus [1] ships a distributed Postgres. A lot of the things they improve would help massively with analytical workloads actually. 1: https://www.citusdata.com/ https://www.citusdata.com/
- riku_iki 5y agoYou misspelled cit<r>us, the same is in the blogpost.
- cedricd 5y agoAhh! So sorry. Fixed it.
- cedricd 5y agoAlso, what's your take? Do people use citus for analytical workloads as well as production at scale? I'd assume yes, but I haven't personally used you guys. I'm just aware of you and broadly how you scale Postgres.
- riku_iki 5y agoSorry, I am not familiar with citus.
- deleted 5y ago[deleted]