Re: Database multi-threading

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