Re: process big

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

In response to

Browse pgsql-general by date

  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