I am running pg_dump on a database while on another machine running a loop to do insertions.
Does pg_dump wait for idle activity before it completes or how does it determine when it has all the records needed for archiving? I am using the compressed mode and also using xz. Thanks, ap