| From: | Frank Bax <fbax(at)sympatico(dot)ca> |
|---|---|
| To: | "Travis Hoyt" <thoyt(at)npc(dot)net> |
| Cc: | "Postgres" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Database multi-threading |
| Date: | 2002-02-15 19:48:40 |
| Message-ID: | 3.0.6.32.20020215144840.01ba79a0@pop6.sympatico.ca |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Reyes | 2002-02-15 21:03:42 | Re: Upgrading to 7.2 |
| Previous Message | Travis Hoyt | 2002-02-15 19:35:49 | Database multi-threading |