| From: | Erik Jones <erik(at)myemma(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Slow dump? |
| Date: | 2007-01-02 16:41:53 |
| Message-ID: | 459A8B51.8000906@myemma.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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(at)myemma(dot)com>
software development
emma(r)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeremy Haile | 2007-01-02 17:06:24 | Re: Config parameters |
| Previous Message | Richard Huxton | 2007-01-02 16:34:19 | Re: Config parameters |