Обсуждение: question

Поиск
Список
Период
Сортировка

question

От
Linh Luong
Дата:
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

Re: question

От
"Dave Cramer"
Дата:
Check out www.greatbridge.com for performace tests. Postgres compared quite
favourably to Oracle, and MS

To answer your question; no postmaster won't die.

Remember the system probably isn't doing anything else so why not give
postmaster 100% of the cpu?

--dc--
----- Original Message -----
From: "Linh Luong" <linh.luong@computalog.com>
To: <pgsql-general@postgresql.org>
Sent: Thursday, May 24, 2001 12:18 PM
Subject: [GENERAL] question


> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>