3 ms·
I would argue thats an issue with your architecture at that point - you may want to use table partitioning at sizes that big, or have some other mechanism in pl
by djd20 8y ago
I would argue thats an issue with your architecture at that point - you may want to use table partitioning at sizes that big, or have some other mechanism in place to be able to lock access while updating such large data sets in one go.
- snuxoll 8y agoI would generally agree, though there are unfortunately limitations imposed on you the moment you start using partitioning with PostgreSQL (foreign keys remain to be a big one).