Re: Postgres CPU usage

From: "Thalis A(dot) Kalfigopoulos" <thalis(at)cs(dot)pitt(dot)edu>
To: Linh Luong <linh(dot)luong(at)computalog(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres CPU usage
Date: 2001-05-24 17:35:25
Message-ID: Pine.LNX.4.21.0105241330570.317-100000@aluminum.cs.pitt.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)luong(at)computalog(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thalis A. Kalfigopoulos 2001-05-24 18:58:36 OID wrap around
Previous Message Linh Luong 2001-05-24 17:09:15 Postgres CPU usage