Re: Index Creation is slow after server change

"Peter A. Daly" <petedaly(at)ix(dot)netcom(dot)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