Postgres 8.1 Linux Redhat AS 4.X 4 processor box We have 12+ schemas in 1 database. When I do a unix “top”
command I notice one postmaster process has 100% CPU usage. This process just stays
at 100% to 99% CPU usage. There are other postmaster processes that pop up.
They use hardly no CPU or memory. They also disappear very fast. I am
wondering, is postgres only using one processor for database queries? Is there
something I need to do to tell postgres to use more than one processor? Or
does postgres only use up to one processor for any particular database? Thanks for your help, Lance Campbell Project Manager/Software Architect Web Services at Public Affairs 217.333.0382 http://webservices.uiuc.edu |