From: | rahulraveendran <rahul(dot)raveendran(at)au(dot)fujitsu(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: pgpgout/s without swapping--what does it mean? |
Date: | 2015-09-29 09:34:31 |
Message-ID: | 1443519271064-5867809.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi ,
Me too have the same issue on PosgreSQL server. pgpgout/s is going high and
the same time didn't observe any swapping or memory pressure on the host.
Please refer below sar O/P.
12:00:01 PM pgpgin/s pgpgout/s fault/s majflt/s pgfree/s pgscank/s
pgscand/s pgsteal/s %vmeff
12:10:01 PM 0.00 4.16 114.55 0.00 106.62 0.00
0.00 0.00 0.00
12:20:01 PM 0.00 3.94 38.37 0.00 57.85 0.00
0.00 0.00 0.00
12:30:01 PM 7.63 4.65 206.51 0.07 108.31 0.00
0.00 0.00 0.00
12:40:01 PM 3.08 4.99 110.57 0.02 93.15 0.00
0.00 0.00 0.00
12:50:01 PM 0.39 4.43 133.92 0.00 88.53 0.00
0.00 0.00 0.00
01:00:01 PM 0.00 4.93 134.93 0.00 88.07 0.00
0.00 0.00 0.00
01:10:01 PM 17.10 20652.46 233.39 0.18 14035.87 4165.03
0.00 4164.51 99.99
01:20:01 PM 9.37 15831.25 140.93 0.13 11912.22 4116.36
0.00 4116.36 100.00
01:30:01 PM 15.40 19688.21 164.96 0.18 14261.36 4938.36
0.00 4938.32 100.00
01:40:01 PM 11.52 11529.86 149.57 0.12 8133.76 2784.77
0.00 2784.77 100.00
01:50:01 PM 9.16 12416.42 140.14 0.13 8890.65 3057.49
0.00 3057.49 100.00
02:00:01 PM 12.19 9076.26 142.05 0.11 6756.87 2320.05
1.88 2321.92 100.00
02:10:01 PM 14.29 12839.23 219.15 0.17 9501.58 3257.99
0.00 3257.99 100.00
02:20:01 PM 12.78 10694.65 145.12 0.11 8268.03 2465.23
0.00 2465.23 100.00
02:30:01 PM 5.79 4.93 140.92 0.03 94.61 0.00
0.00 0.00 0.00
02:40:01 PM 0.06 4.57 147.94 0.00 109.82 0.00
0.00 0.00 0.00
02:50:01 PM 4.94 5.11 140.54 0.03 94.58 0.00
0.00 0.00 0.00
03:00:01 PM 0.00 4.92 138.82 0.00 94.25 0.00
0.00 0.00 0.00
03:10:01 PM 7.66 7.84 267.43 0.12 177.26 0.00
0.00 0.00 0.00
03:20:01 PM 0.00 4.57 138.89 0.00 94.06 0.00
0.00 0.00 0.00
03:30:01 PM 0.00 4.85 140.98 0.00 95.61 0.00
0.00 0.00 0.00
03:40:01 PM 0.00 4.54 148.36 0.00 110.78 0.00
0.00 0.00 0.00
03:50:01 PM 0.00 4.51 137.96 0.00 93.90 0.00
0.00 0.00 0.00
04:00:01 PM 0.00 5.08 143.63 0.00 95.18 0.00
0.00 0.00 0.00
04:10:01 PM 22.53 50746.42 230.90 0.22 35820.37 18562.07
0.00 11605.90 62.52
04:20:01 PM 23.93 60429.47 136.53 0.19 43166.45 22012.66
0.00 14525.16 65.99
04:30:01 PM 17.97 3110.80 140.26 0.10 2822.69 1505.53
0.00 601.17 39.93
And also observed that during this time . there some rsync jobs started by
pgsql and consuming CPU resources.
% CPU PID
30.8 10452 sshd
24.9 10454 rsync
3.0 10455 flush-253:2
postgres 10452 30.8 0.1 104372 6256 ? S 16:00 6:02 sshd:
postgres(at)notty
postgres 10453 0.0 0.0 110512 1496 ? Ss 16:00 0:00 rsync
--server -logDtpre.iLs . /backup/ARCHIVELOGS/CLUSTER1
postgres 10454 24.9 0.0 110772 1056 ? S 16:00 4:53 rsync
--server -logDtpre.iLs . /backup/ARCHIVELOGS/CLUSTER1
root 10455 3.0 0.0 0 0 ? S 16:00 0:35
[flush-253:2]
VM stat .
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu-----
r b swpd free buff cache si so bi bo in cs us sy id
wa st
2 1 15704 173136 234692 5197108 0 0 167 4141 1 1 3 2 93
2 0
0 1 15704 120684 234692 5250312 0 0 0 242356 4374 3450 18 17 25
39 0
1 0 15704 131224 234688 5247532 0 0 0 102396 5525 2630 22 17 45
16 0
2 0 15704 159744 234688 5219992 0 0 0 56 3809 2555 17 10 74
0 0
1 0 15704 157636 234688 5221132 0 0 0 172 6719 4522 26 16 58
0 0
Can anyone suggest how to get rid of this pageout alert.
--
View this message in context: http://postgresql.nabble.com/pgpgout-s-without-swapping-what-does-it-mean-tp5796346p5867809.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2015-09-29 11:12:51 | Re: WAL Shipping and streaming replication |
Previous Message | Andreas Joseph Krogh | 2015-09-29 07:21:45 | Re: Format |