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:Well you're connecting to localhost so I'd expect you to show a memory
>
> 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?
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: