Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Hmmm ... AFAIR there isn't a good reason for dump to custom format
> to take longer than plain text dump, except for applying
> compression. Maybe -Z0 would be worth testing? Or is the problem
> that you have to write the data to a disk file rather than just
> piping it?
I'm not sure without benchmarking that. I was writing to the same
RAID as the database I was dumping, so contention was probably a
significant issue. But it would be interesting to compare different
permutations to see what impact each has alone and in combination.
I'm OK with setting up a benchmark run each night for a while, to
shake out what I can, on this and the artificial cases.
In response to
pgsql-performance by date
|Next:||From: Stefan Kaltenbrunner||Date: 2009-07-30 18:14:19|
|Subject: Re: PostgreSQL 8.4 performance tuning questions|
|Previous:||From: Tom Lane||Date: 2009-07-30 17:28:15|
|Subject: Re: PostgreSQL 8.4 performance tuning questions |