Search Postgresql Archives

Re: pgpgout/s without swapping--what does it mean?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux