postgresql

batch.sql

DO $$ 
DECLARE
    counter integer := 1;
    batch_size integer := 100;
BEGIN
    WHILE counter <= 10000 LOOP
        -- Use the counter to generate unique table names
        EXECUTE 'CREATE TABLE IF NOT EXISTS "customer_histories_' || counter || '" PARTITION OF "customer_histories" FOR VALUES WITH (MODULUS 10000, REMAINDER ' || (counter - 1)::int || ');';
        counter := counter + 1;

		-- WHILE NOT EXISTS (SELECT 1 FROM pg_indexes WHERE tablename = 'table_' || counter) LOOP
        --     PERFORM pg_sleep(1); -- Wait for 1 second
        -- END WHILE;

        -- Commit every batch_size tables
        IF counter % batch_size = 0 THEN
            COMMIT;
        END IF;
    END LOOP;

    -- Commit any remaining tables
    COMMIT;
END $$;