Your system should use multiple processors when you have concurrent
connections active. A restore from a pg_dumpall file only uses one
connection. If you had create separate pg_dump files from your old system,
then start restore on each file separately; you would then use multiple
processors.
Frank
At 02:35 PM 2/15/02 -0500, Travis Hoyt wrote:
>Greetings,
>
>Just got lucky enough to swipe an 8 processor server and I'm trying to find
>out how I can make the most of my resources. Doing a restore from a
>pg_dumpall I see that the postmaster is basically dogging one CPU. Anyone
>know how I can make the postmaster share the love? Any info on general
>performance enchancements would be greatly appreciated as well. This system
>has lots of disk space, 2 Gb of memory and again 8 processors. Any thoughts
>would be appreciated.
>
>Thanks,
>
>Travis