Re: Memory issues

From: Shiran Kleiderman <shirank1(at)gmail(dot)com>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Memory issues
Date: 2012-09-26 16:41:48
Message-ID: CAGYUkGXnmqKEFAE0vJwMubh5jdz7iiS7z16XrEQL21=aj+ajFg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-performance

Hi
Thanks again.
Right now, this is *free -m and ps aux* and non of the crons can run -
can't allocate memory.

cif(at)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(at)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(at)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(dot)marlowe(at)gmail(dot)com>wrote:

> On Tue, Sep 25, 2012 at 7:00 PM, Shiran Kleiderman <shirank1(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message SUNDAY A. OLUTAYO 2012-09-26 16:42:41 trigger and plpgsq help needed
Previous Message Scott Marlowe 2012-09-26 16:29:07 Re: Memory issues

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Sosinski 2012-09-26 18:38:09 Inaccurate Explain Cost
Previous Message Nikolay Ulyanitsky 2012-09-26 16:30:30 Re: Same query doing slow then quick