From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | FernAndo <fern(at)netlan(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: process big |
Date: | 2003-08-29 10:23:32 |
Message-ID: | 20030829102332.GA14973@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)postgresql(dot)org)
--
Martijn van Oosterhout <kleptog(at)svana(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-08-29 10:40:35 | Re: Functions have 32 args limt ??? |
Previous Message | Dennis Björklund | 2003-08-29 10:13:50 | Re: mysql's last_insert_id |