pg_partman icon indicating copy to clipboard operation
pg_partman copied to clipboard
verified publisher icon pgpartman

Run partition_data_proc in parallel

Open maxpain opened this issue 3 years ago • 2 comments

Hello. I have a table with 600 million rows (60 GB). partition_data_proc procedure took about 6 hours. Is it possible to run this migration in parallel?

maxpain avatar May 28 '22 23:05 maxpain

At this time, I'm not sure how this could be done. If anyone else has any ideas how to implement this through an extension, I'd appreciate the help.

keithf4 avatar May 31 '22 14:05 keithf4

Possible idea here... Allow the partition_data_proc to have start/end boundary parameters. If those are provided, do not set the advisory lock. Would not automatically do parallel data migration, but could possibly allow the user to call it multiple times.

keithf4 avatar Mar 29 '23 15:03 keithf4