Re: More 8.2 client issues (Was: [Slow dump?)

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

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