process big
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
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 FreePID 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/
Show quoted text
"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