Content Comparison

...

1. Create new table with INT PK:

   Code Block
   sql CREATE TABLE mutationcore_logMutation_newLog ( id BIGSERIAL PRIMARY KEY, uuid UUID NOT NULL UNIQUE, ... existing columns ... );

2. Batch copy data (500k records/batch):

   Code Block
   sql INSERT INTO mutationcore_logMutation_newLog (uuid, json_content, ...) SELECT uuid, json_content, ... FROM mutation_log;

3. Atomic switch during maintenance window:

   Code Block
   sql ALTER TABLE mutationcore_Mutation_logLog RENAME TO mutation_log_old; ALTER TABLE mutationcore_logMutation_newLog2 RENAME TO mutationcore_Mutation_logLog;

Performance Expectations

...