4 ms·
what is the best way to shard on postgres?
by arrty88 9y ago
what is the best way to shard on postgres?
- zie 9y agoThere are tons of ways to do that, the lazy way would probably be pay someone like Citus (https://www.citusdata.com/product https://www.citusdata.com/product). Alternatively, use a 3rd party tool, do manual sharding, or the PG FDW, or ... the list is pretty endless. Depends a lot on your needs, requirements, how much sharding you have to do, etc. It's not a simple topic. First I'd make sure your DB sizes really NEED that before going down that road, it's a lot of hassle, and I'd personally push for just sizing your DB box up and up and up before going down that road if at all possible. Simple solutions(read: not sharding) usually win, especially when production falls over and you have to prop it back up.