Postgres CPU usage
Hi all,
I am running postgres7.1 and php4.0. When I do top while running my
query via browser I notice that the postmaster process takes up almost
100% of the CPU and this is just for one user. What would happen if
multiple users does the same search at the same time would the
postmaster die?
Thanks
--
Linh Luong
Computalog Ltd.
Software Developer
Phone: (780) 464-6686 (ext 325)
Email: linh.luong@computalog.com
On Thu, 24 May 2001, Linh Luong wrote:
Hi all,
I am running postgres7.1 and php4.0. When I do top while running my
query via browser I notice that the postmaster process takes up almost
100% of the CPU and this is just for one user. What would happen if
multiple users does the same search at the same time would the
postmaster die?Thanks
--
Linh Luong
Computalog Ltd.
Software Developer
Phone: (780) 464-6686 (ext 325)
Email: linh.luong@computalog.com
Well if your CPU is idle, shouldn't someone do smthing usefull with it :-)
If N users do the sam search postmaster wouldn't die.
Go through http://www.postgresql.org/idocs/index.php?arch.html wrt the Postgres architecture.
cheers,
thalis