Erik Jones <erik(at)myemma(dot)com> 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