2026-09-20 04:42 UTC
Update: I'm chunking the inserts, because it's all being run in a single transaction. Here's my current query:
insert into status_stats_new select * from status_stats where id >= (select max(id)+1 from status_stats_new) order by id limit 100000;
Yes., that's doing 100k at a time, but only takes 30-40 seconds per chunk.
Replies (1)
-
@xrobau@mastodon.au 2026-09-20 04:49
31 seconds is surprisingly fast for 100k inserts. Oh well, I'll just keep going and hope I find the derped up records. #PostgreSQL #MastodonNZ