"Peter A. Daly" <petedaly@ix.netcom.com> writes:
> Any ideas why this would take almost 3 times as long on what, other than
> 166Mhz per CPU, is a much more heavy duty server? I have more memory
> available for shared buffers than postgres is using on the import (1.75g
> allowed, its using about 1.1g max). I only allow postgres on the old
> machine 808mb, and it uses it all. I currently have 4000 log buffers,
> with 8 log files created.
More shared buffers are not necessarily better. Have you tried running
with shared_buffers adjusted to take about a quarter of physical RAM,
rather than nearly all of it? And I really fail to see the point of
4000 WAL buffers...
regards, tom lane