I found today that I can't execute this:
UPSERT INTO loadtest.testing (id, firstname, lastname) SELECT NEXT VALUE
FOR loadtest.testing_id_seq, firstname, lastname FROM loadtest.testing
when the table has more than 500,000 rows in it ("MutationState size of
512000 is bigger than max allowed size of 500000").
Is there a reason for the restriction, or a way of lifting it so that
things get processed in batches?
Does this also mean that if I had a large table, and I wanted to (say)
null out one of the columns, I wouldn't be able to do it in one hit
because I'd be changing too many rows?
James
|