Tom Lane <tgl@xxxxxxxxxxxxx> 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. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
