Postgres CPU usage

Started by Linh Luongalmost 25 years ago2 messagesgeneral
Jump to latest
#1Linh Luong
linh.luong@computalog.com

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

#2Thalis A. Kalfigopoulos
thalis@cs.pitt.edu
In reply to: Linh Luong (#1)
Re: Postgres CPU usage

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