PG version 15.4
i read code about pg_dump & pg_restore, there is an option -j/--jobs 
related with parallel,
i have questions about parallel dump & restore
1) In pg_dump when running parallel dump, it can ensure dump data 
consistency using synchronized snaphot,

why should it start a trasaction in every parallel jobs, also set isolation 
level ,read only, and no need commit trasaction
2) In pg_restore there are no actions same with pg_dump under parallel 
mode, how to ensure restore data consistency?

no trasaction and no commit action
3) when we do dump or restore under parallel mode, should we set whole 
database read-only(write behavior forbidden??)



发自我的企业微信

Reply via email to