Re: Memory issues - Mailing list pgsql-general

From Shiran Kleiderman
Subject Re: Memory issues
Date
Msg-id CAGYUkGXnmqKEFAE0vJwMubh5jdz7iiS7z16XrEQL21=aj+ajFg@mail.gmail.com
Whole thread Raw
In response to Re: Memory issues  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Hi
Thanks again.
Right now, this is free -m and ps aux and non of the crons can run - can't allocate memory.

cif@domU-12-31-39-08-06-20:~$ free -m
             total       used       free     shared    buffers     cached
Mem:         17079      12051       5028          0        270       9578
-/+ buffers/cache:       2202      14877
Swap:          511          0        511


cif@domU-12-31-39-08-06-20:~$ ps aux
USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
root         1  0.0  0.0  24316  2280 ?        Ss   Sep24   0:00 /sbin/init
root         2  0.0  0.0      0     0 ?        S    Sep24   0:00 [kthreadd]
root         3  0.0  0.0      0     0 ?        S    Sep24   0:00 [ksoftirqd/0]
root         4  0.0  0.0      0     0 ?        S    Sep24   0:00 [kworker/0:0]
root         5  0.0  0.0      0     0 ?        S    Sep24   0:00 [kworker/u:0]
root         6  0.0  0.0      0     0 ?        S    Sep24   0:00 [migration/0]
root         7  0.0  0.0      0     0 ?        S    Sep24   0:00 [watchdog/0]
root         8  0.0  0.0      0     0 ?        S    Sep24   0:00 [migration/1]
root         9  0.0  0.0      0     0 ?        S    Sep24   0:00 [kworker/1:0]
root        10  0.0  0.0      0     0 ?        S    Sep24   0:01 [ksoftirqd/1]
root        11  0.0  0.0      0     0 ?        S    Sep24   0:00 [watchdog/1]
root        12  0.0  0.0      0     0 ?        S<   Sep24   0:00 [cpuset]
root        13  0.0  0.0      0     0 ?        S<   Sep24   0:00 [khelper]
root        14  0.0  0.0      0     0 ?        S    Sep24   0:00 [kdevtmpfs]
root        15  0.0  0.0      0     0 ?        S<   Sep24   0:00 [netns]
root        16  0.0  0.0      0     0 ?        S    Sep24   0:00 [kworker/u:1]
root        17  0.0  0.0      0     0 ?        S    Sep24   0:00 [xenwatch]
root        18  0.0  0.0      0     0 ?        S    Sep24   0:00 [xenbus]
root        19  0.0  0.0      0     0 ?        S    Sep24   0:00 [sync_supers]
root        20  0.0  0.0      0     0 ?        S    Sep24   0:00 [bdi-default]
root        21  0.0  0.0      0     0 ?        S<   Sep24   0:00 [kintegrityd]
root        22  0.0  0.0      0     0 ?        S<   Sep24   0:00 [kblockd]
root        23  0.0  0.0      0     0 ?        S<   Sep24   0:00 [ata_sff]
root        24  0.0  0.0      0     0 ?        S    Sep24   0:00 [khubd]
root        25  0.0  0.0      0     0 ?        S<   Sep24   0:00 [md]
root        26  0.0  0.0      0     0 ?        S    Sep24   0:02 [kworker/0:1]
root        28  0.0  0.0      0     0 ?        S    Sep24   0:00 [khungtaskd]
root        29  0.0  0.0      0     0 ?        S    Sep24   0:00 [kswapd0]
root        30  0.0  0.0      0     0 ?        SN   Sep24   0:00 [ksmd]
root        31  0.0  0.0      0     0 ?        S    Sep24   0:00 [fsnotify_mark]
root        32  0.0  0.0      0     0 ?        S    Sep24   0:00 [ecryptfs-kthrea]
root        33  0.0  0.0      0     0 ?        S<   Sep24   0:00 [crypto]
root        41  0.0  0.0      0     0 ?        S<   Sep24   0:00 [kthrotld]
root        42  0.0  0.0      0     0 ?        S    Sep24   0:00 [khvcd]
root        43  0.0  0.0      0     0 ?        S    Sep24   0:01 [kworker/1:1]
root        62  0.0  0.0      0     0 ?        S<   Sep24   0:00 [devfreq_wq]
root       176  0.0  0.0      0     0 ?        S<   Sep24   0:00 [kdmflush]
root       187  0.0  0.0      0     0 ?        S    Sep24   0:01 [jbd2/xvda1-8]
root       188  0.0  0.0      0     0 ?        S<   Sep24   0:00 [ext4-dio-unwrit]
root       258  0.0  0.0  17224   640 ?        S    Sep24   0:00 upstart-udev-bridge --daemon
root       265  0.0  0.0  21460  1196 ?        Ss   Sep24   0:00 /sbin/udevd --daemon
root       328  0.0  0.0  21456   712 ?        S    Sep24   0:00 /sbin/udevd --daemon
root       329  0.0  0.0  21456   716 ?        S    Sep24   0:00 /sbin/udevd --daemon
root       389  0.0  0.0  15180   392 ?        S    Sep24   0:00 upstart-socket-bridge --daemon
root       419  0.0  0.0   7256  1008 ?        Ss   Sep24   0:00 dhclient3 -e IF_METRIC=100 -pf /var/run/dhclient.eth0.pid -lf /var/lib/dhcp/dhclient.eth0.leases -1 eth
root       574  0.0  0.0      0     0 ?        S    Sep24   0:03 [jbd2/dm-0-8]
root       575  0.0  0.0      0     0 ?        S<   Sep24   0:00 [ext4-dio-unwrit]
root       610  0.0  0.0  49948  2880 ?        Ss   Sep24   0:00 /usr/sbin/sshd -D
syslog     625  0.0  0.0 253708  1552 ?        Sl   Sep24   0:11 rsyslogd -c5
102        630  0.0  0.0  23808   944 ?        Ss   Sep24   0:00 dbus-daemon --system --fork --activation=upstart
root       687  0.0  0.0  14496   968 tty4     Ss+  Sep24   0:00 /sbin/getty -8 38400 tty4
root       696  0.0  0.0  14496   972 tty5     Ss+  Sep24   0:00 /sbin/getty -8 38400 tty5
root       708  0.0  0.0  14496   968 tty2     Ss+  Sep24   0:00 /sbin/getty -8 38400 tty2
root       710  0.0  0.0  14496   964 tty3     Ss+  Sep24   0:00 /sbin/getty -8 38400 tty3
root       715  0.0  0.0  14496   968 tty6     Ss+  Sep24   0:00 /sbin/getty -8 38400 tty6
root       720  0.0  0.0   4320   660 ?        Ss   Sep24   0:00 acpid -c /etc/acpi/events -s /var/run/acpid.socket
root       728  0.0 11.9 2194848 2097324 ?     Ss   Sep24   0:09 /usr/bin/searchd --nodetach
root       733  0.0  0.0  19104   928 ?        Ss   Sep24   0:00 cron
daemon     735  0.0  0.0  16900   376 ?        Ss   Sep24   0:00 atd
bind       739  0.0  0.0 235540 13404 ?        Ssl  Sep24   0:00 /usr/sbin/named -u bind
mysql      755  0.0  0.2 558104 47940 ?        Ssl  Sep24   0:34 /usr/sbin/mysqld
whoopsie   790  0.0  0.0 187576  4236 ?        Ssl  Sep24   0:00 whoopsie
root       924  0.0  0.0      0     0 ?        S    Sep24   0:00 [flush-252:0]
root       999  0.0  0.0  99400  6496 ?        Ss   Sep24   0:04 /usr/sbin/apache2 -k start
www-data  1018  0.0  1.0 427080 185684 ?       S    Sep24   0:10 /usr/sbin/apache2 -k start
www-data  1019  0.0  1.0 427140 185852 ?       S    Sep24   0:33 /usr/sbin/apache2 -k start
root      1032  0.0  0.1  80220 21276 ?        Ss   Sep24   0:17 starman master --port 5000 --daemonize -MMoose /usr/local/cif-rest-sphinx/CIF.psgi
root      1035  0.0  0.0  14496   968 tty1     Ss+  Sep24   0:00 /sbin/getty -8 38400 tty1
root      1037  0.0  0.1 184400 28532 ?        S    Sep24   0:00 starman worker --port 5000 --daemonize -MMoose /usr/local/cif-rest-sphinx/CIF.psgi
root      1038  0.0  0.1 184444 28592 ?        S    Sep24   0:00 starman worker --port 5000 --daemonize -MMoose /usr/local/cif-rest-sphinx/CIF.psgi
root      1039  0.0  0.1 184132 28040 ?        S    Sep24   0:00 starman worker --port 5000 --daemonize -MMoose /usr/local/cif-rest-sphinx/CIF.psgi
root      1040  0.0  0.1 184408 28600 ?        S    Sep24   0:00 starman worker --port 5000 --daemonize -MMoose /usr/local/cif-rest-sphinx/CIF.psgi
root      1041  0.0  0.1 184444 28588 ?        S    Sep24   0:00 starman worker --port 5000 --daemonize -MMoose /usr/local/cif-rest-sphinx/CIF.psgi
www-data  1055  0.0  1.2 469948 225732 ?       S    Sep24   1:04 /usr/sbin/apache2 -k start
www-data  1056  0.0  1.0 427180 185924 ?       S    Sep24   0:28 /usr/sbin/apache2 -k start
www-data  3452  0.0  1.0 426964 185624 ?       S    Sep25   0:28 /usr/sbin/apache2 -k start
www-data  3775  0.0  1.0 426900 185696 ?       S    Sep25   0:14 /usr/sbin/apache2 -k start
postgres  4717  0.0  0.6 4411584 113372 ?      S    Sep25   0:01 /usr/lib/postgresql/9.1/bin/postgres -D /mnt/dbstorage/9.1/main -c config_file=/etc/postgresql/9.1/main
postgres  4720  0.0  0.1 4413628 31392 ?       Ss   Sep25   0:09 postgres: writer process
postgres  4721  0.0  0.0 4413636 1808 ?        Ss   Sep25   0:08 postgres: wal writer process
postgres  4722  0.0  0.0 4414344 3044 ?        Ss   Sep25   1:36 postgres: autovacuum launcher process
postgres  4723  0.0  0.0  94920  1752 ?        Ss   Sep25   0:41 postgres: stats collector process
postgres  4738  0.0  7.0 4491580 1229488 ?     Ss   Sep25   0:58 postgres: postgres cif 127.0.0.1(56867) idle
postgres  4740  0.0  6.9 4417748 1221100 ?     Ss   Sep25   0:18 postgres: postgres cif 127.0.0.1(56869) idle
postgres  4741  0.0  7.0 4425720 1228856 ?     Ss   Sep25   0:31 postgres: postgres cif 127.0.0.1(56870) idle
postgres  4742  0.0  6.9 4417376 1220464 ?     Ss   Sep25   0:08 postgres: postgres cif 127.0.0.1(56871) idle
postgres  4743  0.0  7.0 4421104 1225328 ?     Ss   Sep25   0:24 postgres: postgres cif 127.0.0.1(56872) idle
postgres  4745  0.0  7.0 4421124 1225040 ?     Ss   Sep25   0:27 postgres: postgres cif 127.0.0.1(56874) idle
www-data  4746  0.0  1.2 455984 212284 ?       S    Sep25   0:30 /usr/sbin/apache2 -k start
postgres  4754  0.0  6.9 4417728 1220988 ?     Ss   Sep25   0:30 postgres: postgres cif 127.0.0.1(56879) idle
www-data  4755  0.0  0.9 403836 163240 ?       S    Sep25   0:06 /usr/sbin/apache2 -k start
postgres  4765  0.0  6.9 4482528 1220704 ?     Ss   Sep25   0:23 postgres: postgres cif 127.0.0.1(56881) idle
www-data  4995  0.0  0.9 403464 162872 ?       S    Sep25   0:03 /usr/sbin/apache2 -k start
www-data  4997  0.0  0.3 305460 64996 ?        S    Sep25   0:00 /usr/sbin/apache2 -k start
postgres  5002  0.0  6.9 4417384 1220172 ?     Ss   Sep25   0:09 postgres: postgres cif 127.0.0.1(56895) idle
postgres  5003  0.0  7.1 4417920 1243772 ?     Ss   Sep25   0:06 postgres: postgres cif 127.0.0.1(56896) idle
root      5218  0.0  0.0      0     0 ?        S    Sep25   0:00 [flush-202:1]
root      5820  0.0  0.0  73352  3568 ?        Ss   16:37   0:00 sshd: ubuntu [priv]
ubuntu    5950  0.0  0.0  73352  1676 ?        S    16:37   0:00 sshd: ubuntu@pts/0
ubuntu    5952  0.6  0.0  25872  8432 pts/0    Ss   16:37   0:00 -bash
root      6048  0.0  0.0  41896  1752 pts/0    S    16:38   0:00 sudo su - cif
cif       6049  0.0  0.0  39516  1388 pts/0    S    16:38   0:00 su - cif
cif       6050  0.8  0.0  25912  8472 pts/0    S    16:38   0:00 -su
cif       6161  0.0  0.0  16872  1272 pts/0    R+   16:38   0:00 ps aux


On Wed, Sep 26, 2012 at 6:29 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
On Tue, Sep 25, 2012 at 7:00 PM, Shiran Kleiderman <shirank1@gmail.com> wrote:
>
> Hi
> Thanks for your answer.
> I understood that the server is ok memory wise.
> What can I check on the client side or the DB queries?

Well you're connecting to localhost so I'd expect you to show a memory
issue in free I'm not seeing.  Are you really connecting to localhost
or not?



--
Best,
Shiran Kleiderman
+972  - 542380838
Skype - shirank1

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Memory issues
Next
From: Jeff Janes
Date:
Subject: Re: PostgreSQL data loads - turn off WAL