Thread: process big

process big

From
"FernAndo"
Date:
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




Re: process big

From
Martijn van Oosterhout
Date:
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