Re: process big - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: process big
Date
Msg-id 20030829102332.GA14973@svana.org
Whole thread Raw
In response to process big  ("FernAndo" <fern@netlan.net>)
List pgsql-general
Most of that is probably shared memory. What size gave you set that to?

On Wed, Aug 27, 2003 at 11:48:35AM -0300, FernAndo wrote:
> my freebsd 4,7 this creating processes big of postgresql.
> help me with some information?
>
> PostgreSQL 7.3.1
>
>
> CPU states:  0.0% user,  0.0% nice,  0.0% system,  0.0% interrupt,  100%
> idle
> Mem: 221M Active, 1890M Inact, 272M Wired, 118M Cache, 199M Buf, 9256K Free
> Swap: 1024M Total, 276K Used, 1024M Free
>
>   PID USERNAME  PRI NICE  SIZE    RES STATE    TIME   WCPU    CPU COMMAND
> 78121 postgres    2   0   128M   125M sbwait   2:07  6.40%  6.40% postgres
> 78415 postgres    2   0   128M 46572K sbwait   0:02  1.61%  1.61% postgres
> 76831 postgres    2   0   130M   126M sbwait   0:32  0.00%  0.00% postgres
> 76833 postgres    2   0   130M   126M sbwait   0:24  0.00%  0.00% postgres
> 78115 postgres    2   0   128M   115M sbwait   0:23  0.00%  0.00% postgres
>   140 postgres    2   0   126M  1652K select   0:19  0.00%  0.00% postgres
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato

Attachment

pgsql-general by date:

Previous
From: Dennis Björklund
Date:
Subject: Re: mysql's last_insert_id
Next
From: Richard Huxton
Date:
Subject: Re: Functions have 32 args limt ???