when upserting many is there a known reccomendation for maximum number of rows (postgres)? I realize this is a huge and very fuzzy request but — for instance — should you hammer ALL of your data in regardless of the row count? is it better for overall performance to have smaller chunks?
✅ 1
n
Nurul
08/24/2022, 8:41 AM
Hey Dave 👋
This would ideally depend on the database memory as well, It could happen that adding too much data in a single query could lead to out-of-memory error. To me, it seems to add smaller chunks of data would be ideal.