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@postgresql.org [mailto:pgsql-general-
> owner@postgresql.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
>