3 ms·
I found having big doc store tables in Postgres became harder to manage as time went by from a people perspective. E.g. around the 300GB mark I had to constant
by janee 4y ago
I found having big doc store tables in Postgres became harder to manage as time went by from a people perspective.
E.g. around the 300GB mark I had to constantly remind myself and others to be careful of it because it might have normal relational columns you think are fine to query, but it also has a fat json payload on each row and if you're careless the query planner would basically do a table scan for things you wouldn't expect.
This isn't so much a problem with json in an rdbms but more the false sense of query performance on non-json columns in the same table...after moving it to mongo never had the same problems because people knew not to query it in an unsupported manner.
- cpursley 4y agoInteresting, something to keep in mind!