Slow dump?

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: Raw Message | Whole Thread | 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)

Responses

Browse pgsql-performance by date

  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