From: Erik Jones <erik@myemma.com>
To: pgsql-performance@postgresql.org
Subject: Slow dump?
Date: Tue, 02 Jan 2007 10:41:53 -0600
Message-ID: <459A8B51.8000906@myemma.com> (raw)
Hello, we recently migrated our system from 8.1.x to 8.2 and when
running dumps have noticed an extreme decrease in speed where the dump
is concerned (by more than a factor of 2). I was wondering if someone
might offer some suggestions as to what may be causing the problem. How
important are max_fsm_pages and max_fsm_relations to doing a dump? I
was just looking over your config file and that's the only thing that
jumped out at me as needing to be changed.
Machine info:
OS: Solaris 10
Sunfire X4100 XL
2x AMD Opteron Model 275 dual core procs
8GB of ram
Pertinent postgres settings:
shared_buffers: 50000
work_mem: 8192
maintenance_work_mem: 262144
max_stack_depth: 3048 (default)
There doesn't seem to be any other performance degradation while the
dump is running (which I suppose is good). Any ideas?
--
erik jones <erik@myemma.com>
software development
emma(r)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: erik@myemma.com
Subject: Re: Slow dump?
In-Reply-To: <459A8B51.8000906@myemma.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox