Erik Jones <erik@xxxxxxxxxx> writes: > Guillaume Smet wrote: >> Could you set log_min_duration_statement=0 on your server and enable > Heh, unfortunately, setting log_min_duration_statement=0 would be a > total last resort as the last we counted (2 months ago) we were doing > approximately 3 million transactions per hour. Do it just for the pg_dump: export PGOPTIONS="--log_min_duration_statement=0" pg_dump ... I don't think that the regex issue explains pg_dump being slow, unless perhaps you are making use of the table-selection switches? regards, tom lane
