Re: pg_dump strangeness

I tried stopping and starting postmaster to see if it would release any
memory and it didn't.

I'll try doing the ps later tonight and see what happens. But here is
some info from top if that helps at all.

The machine in a quit state
5:02pm up 1:30, 1 user, load average: 0.00, 0.00, 0.00
77 processes: 74 sleeping, 3 running, 0 zombie, 0 stopped
CPU states: 0.0% user, 0.1% system, 0.0% nice, 99.8% idle
Mem: 1015028K av, 205732K used, 809296K free, 0K shrd, 38036K
buff
Swap: 136512K av, 0K used, 136512K free 86884K
cached

After 3 consecutive pg_dumps
3:15pm up 5:47, 4 users, load average: 0.06, 0.13, 0.21
111 processes: 108 sleeping, 3 running, 0 zombie, 0 stopped
CPU states: 3.5% user, 1.7% system, 0.3% nice, 94.2% idle
Mem: 1015028K av, 997768K used, 17260K free, 0K shrd, 76016K
buff
Swap: 136512K av, 10484K used, 126028K free 801560K
cached

Last update before died
3:27pm up 6:00, 4 users, load average: 1.65, 1.90, 1.23
110 processes: 106 sleeping, 4 running, 0 zombie, 0 stopped
CPU states: 20.0% user, 20.2% system, 0.1% nice, 59.4% idle
Mem: 1015028K av, 1006508K used, 8520K free, 0K shrd, 76968K
buff
Swap: 136512K av, 10484K used, 126028K free 726256K
cached

PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND
3641 postgres 16 0 110M 110M 26840 R 29.8 11.1 5:20 postmaster
1227 root 5 -10 26152 6128 3008 S < 3.3 0.6 40:35 X
1538 laner 15 0 12096 11M 6124 S 1.5 1.1 2:02 rhn-applet

Thanks again,
Lane

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Joseph Shraibman
> Sent: Monday, March 10, 2003 4:38 PM
> To: Lane Rollins
>
> Lane Rollins wrote:
>
> Do you notice a lot of memory being allocated? Use the free command.
Is
> uptime high?
>
> What is the output of this command (assuming the db is being run by
user
> 'postgres')?
> ps -w -w -o pid,rss,size,args --sort size -u postgres
>