原作者:石勇虎 创作时间:2019-03-19 08:30:29+08 采编:redraiment
发布时间:2019-03-19 08:30:29
欢迎大家踊跃投稿,投稿信箱:press@postgres.cn
评论:3 浏览:6451
1. # cat /var/log/messages | grep -i "out of memory" 2. 07:08:48 cnlf081173 kernel: Out of memory: Kill process 15095 (postgres) score 155 or sacrifice chil
3. 07:08:49.663 CST,,,21174,,5c29bb9e.52b6,23,,2018-12-31 14:47:58 CST,,0,LOG,00000,"server process (PID 15095) was terminated by signal 9: Killed","Failed process was running: SELECT appid, device_type, c_type, c_name, nc_name, status FROM tbl_app_os_ver_channel WHERE appid in …
1. psql (9.5.5) 2. # select pid from pg_stat_activity where query=current_query(); 3. pid 4. ------ 5. 2033 6. (1 row) 7. Time: 8246.251 ms
1. $ pmap -d 2033 2. 2033: postgres: eits: postgres eits [local] idle 3. Address Kbytes Mode Offset Device Mapping 4. mapped: 43811596K writeable/private: 585464K shared: 43100280K
1. # select count(1) from pg_class; 2. count 3. --------- 4. 1713920 5. (1 row)
1. create table tt_pathmantest2(like tt); 2. SELECT create_range_partitions('tt_pathmantest2', 'id', '0'::bigint, '100'::bigint,100000);
1. # select * from pg_stat_activity where query=current_query(); 2. datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start 3. ---------+---------+-------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+------------------------- 4. 3175452 | pgbench | 20213 | 10 | postgres | psql | | | -1 | 2019-02-18 13:46:03.654307+08 | 2019-02-18 13:46:22.9179 5. (1 row) 6. 7. Time: 3844.895 ms 8. $ pmap -d 20213 9. 20213: postgres: pg955: postgres pgbench [local] idle 10. Address Kbytes Mode Offset Device Mapping 11. mapped: 54589524K writeable/private: 332792K shared: 54123512K
6. $ cat /proc/20213/maps 7. 00400000-009aa000 r-xp 00000000 fd:06 43141376 /paic/postgres/base/9.5.5/bin/postgres 8. 00ba9000-00baa000 r--p 005a9000 fd:06 43141376 /paic/postgres/base/9.5.5/bin/postgres 9. 00baa000-00bb6000 rw-p 005aa000 fd:06 43141376 /paic/postgres/base/9.5.5/bin/postgres 10. 00bb6000-00c00000 rw-p 00000000 00:00 0 11. 02a8c000-02ad1000 rw-p 00000000 00:00 0 [heap] 12. 02ad1000-03d69000 rw-p 00000000 00:00 0 [heap] 13. 2ae1bfd62000-2ae1bfd83000 r-xp 00000000 fd:00 67334359 /usr/lib64/ld-2.17.so 14. 2ae1c77ac000-2ae1c77d6000 r-xp 00000000 fd:06 67150233 /paic/postgres/base/9.5.5/lib/pg_pathman.so 15. 2ae1c77d6000-2ae1c79d5000 ---p 0002a000 fd:06 67150233 /paic/postgres/base/9.5.5/lib/pg_pathman.so 16. 2ae1c79d5000-2ae1c79d7000 rw-p 00029000 fd:06 67150233 /paic/postgres/base/9.5.5/lib/pg_pathman.so 17. 2ae1c79d7000-2aeeaf0cf000 rw-s 00000000 00:04 55482843 /dev/zero (deleted) 18. 2aeeaf0cf000-2aeeaf0db000 r-xp 00000000 fd:00 69271978 /usr/lib64/libnss_files-2.17.so 19. 2aeeaf0db000-2aeeaf2da000 ---p 0000c000 fd:00 69271978 /usr/lib64/libnss_files-2.17.so 20. 2aeeaf2da000-2aeeaf2db000 r--p 0000b000 fd:00 69271978 /usr/lib64/libnss_files-2.17.so 21. 2aeeaf2db000-2aeeaf2dc000 rw-p 0000c000 fd:00 69271978 /usr/lib64/libnss_files-2.17.so 22. … … 23. 2aeeaf2dc000-2aeeaf2e2000 rw-p 00000000 00:00 0 24. 2aeeaf344000-2aeeafc8b000 rw-p 00000000 00:00 0 -- 内存大小计算方法c8b000-344000=947000(H)=9728000(D)=9MB 25. 2aeeafccc000-2aeeb06ce000 rw-p 00000000 00:00 0 26. 2aeeb074f000-2aeeb3827000 rw-p 00000000 00:00 0 27. 2aeeb472b000-2aeeb4f2c000 rw-p 00000000 00:00 0 28. 2aeeb572d000-2aeeb672f000 rw-p 00000000 00:00 0 29. 2aeeb6f30000-2aeeb7731000 rw-p 00000000 00:00 0 30. 2aeeb7f32000-2aeeb8733000 rw-p 00000000 00:00 0 31. 2aeeb8f34000-2aeeb9f36000 rw-p 00000000 00:00 0 32. 2aeeba737000-2aeebaf38000 rw-p 00000000 00:00 0 33. 2aeebb739000-2aeebbf3a000 rw-p 00000000 00:00 0 34. 2aeebc73b000-2aeebcf3c000 rw-p 00000000 00:00 0 35. 2aeebd73d000-2aeebe73f000 rw-p 00000000 00:00 0 36. 2aeebef40000-2aeebf741000 rw-p 00000000 00:00 0 37. 2aeebff42000-2aeec0743000 rw-p 00000000 00:00 0 38. 2aeec0f44000-2aeec1f46000 rw-p 00000000 00:00 0 39. 2aeec2747000-2aeec2f48000 rw-p 00000000 00:00 0 40. 2aeec3749000-2aeec3f4a000 rw-p 00000000 00:00 0 41. 2aeec474b000-2aeec584e000 rw-p 00000000 00:00 0 42. 2aeec604f000-2aeec6850000 rw-p 00000000 00:00 0 43. 2aeec7051000-2aeec7852000 rw-p 00000000 00:00 0 44. 2aeec8053000-2aeec9055000 rw-p 00000000 00:00 0 45. 2aeec9856000-2aeeca057000 rw-p 00000000 00:00 0 46. 2aeeca858000-2aeecb059000 rw-p 00000000 00:00 0 47. 2aeecb85a000-2aeecc85c000 rw-p 00000000 00:00 0 48. 2aeecd05d000-2aeecd85e000 rw-p 00000000 00:00 0 49. 2aeece05f000-2aeece361000 rw-p 00000000 00:00 0 50. 7ffc9fac3000-7ffc9fae4000 rw-p 00000000 00:00 0 [stack] 51. 7ffc9fb41000-7ffc9fb43000 r-xp 00000000 00:00 0 [vdso] 52. ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall] 53. (gdb) dump memory /paic/postgres/home/postgres/memory.dump 0x2aeeaf344000 0x2aeeafc8b000 54. $ strings -n 10 memory.dump 55. tt_pathmantest2_19127 56. tt_pathmantest2_19128 57. tt_pathmantest2_19129 58. tt_pathmantest2_19130 59. tt_pathmantest2_19131 60. tt_pathmantest2_19132 …… 61. (gdb) dump memory /paic/postgres/home/postgres/memory.dump 0x2aeeb074f000 0x2aeeb3827000 62. $ strings -n 10 memory.dump 63. pathman_tt_pathmantest2_3219_1_check 64. {BOOLEXPR :boolop and :args ({OPEXPR :opno 415 :opfuncid 472 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 1 :vartype 20 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location -1} {CONST :consttype 20 :consttypmod -1 :constcollid 0 :constlen 8 :constbyval true :constisnull false :location -1 :constvalue 8 [ 8 -23 4 0 0 0 0 0 ]}) :location -1} {OPEXPR :opno 412 :opfuncid 469 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 1 :vartype 20 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location -1} {CONST :consttype 20 :consttypmod -1 :constcollid 0 :constlen 8 :constbyval true :constisnull false :location -1 :constvalue 8 [ 108 -23 4 0 0 0 0 0 ]}) :location -1}) :location -1}o((id >= '321800'::bigint) AND (id < '321900'::bigint)) 65. pathman_tt_pathmantest2_3220_1_check 66. {BOOLEXPR :boolop and :args ({OPEXPR :opno 415 :opfuncid 472 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 1 :vartype 20 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location -1} {CONST :consttype 20 :consttypmod -1 :constcollid 0 :constlen 8 :constbyval true :constisnull false :location -1 :constvalue 8 [ 108 -23 4 0 0 0 0 0 ]}) :location -1} {OPEXPR :opno 412 :opfuncid 469 :opresulttype 16 :opretset false :opcollid 0 :inputcollid 0 :args ({VAR :varno 1 :varattno 1 :vartype 20 :vartypmod -1 :varcollid 0 :varlevelsup 0 :varnoold 1 :varoattno 1 :location -1} {CONST :consttype 20 :consttypmod -1 :constcollid 0 :constlen 8 :constbyval true :constisnull false :location -1 :constvalue 8 [ -48 -23 4 0 0 0 0 0 ]}) :location -1}) :location -1}o((id >= '321900'::bigint) AND (id < '322000'::bigint)) 67. pathman_tt_pathmantest2_3221_1_check ……
1. # drop extension pg_pathman; 2. DROP EXTENSION 3. Time: 233.341 ms 4. # \q 5. 6. $ psql 7. # select * from pg_stat_activity where query =current_query(); 8. datid | datname | pid | usesysid | usename | application_name | client_addr | client_hostname | client_port | backend_start | xact_start 9. -------+---------+-------+----------+----------+------------------+-------------+-----------------+-------------+-------------------------------+--------------------------- 10. 17151 | pgbench | 38928 | 10 | postgres | psql | | | -1 | 2019-02-19 16:02:43.443064+08 | 2019-02-19 16:02:45.953323 11. (1 row) 12. 13. Time: 2.680 ms 14. 15. $ pmap -d 38928 16. mapped: 54259544K writeable/private: 2812K shared: 54123512K
17. /* 18. * Initialize per-process resources. 19. */ 20. static void 21. init_local_cache(void) 22. { 23. HASHCTL ctl; 24. 25. /* Destroy caches, just in case */ 26. hash_destroy(partitioned_rels); 27. hash_destroy(parent_cache); 28. hash_destroy(bound_cache); 29. 30. /* Reset pg_pathman's memory contexts */ 31. if (TopPathmanContext) 32. { 33. /* Check that child contexts exist */ 34. Assert(MemoryContextIsValid(PathmanInvalJobsContext)); 35. Assert(MemoryContextIsValid(PathmanRelationCacheContext)); 36. Assert(MemoryContextIsValid(PathmanParentCacheContext)); 37. Assert(MemoryContextIsValid(PathmanBoundCacheContext)); 38. 39. /* Clear children */ 40. MemoryContextResetChildren(TopPathmanContext); 41. } 42. /* Initialize pg_pathman's memory contexts */ 43. else 44. { 45. Assert(PathmanInvalJobsContext == NULL); 46. Assert(PathmanRelationCacheContext == NULL); 47. Assert(PathmanParentCacheContext == NULL); 48. Assert(PathmanBoundCacheContext == NULL); 49. 50. TopPathmanContext = 51. AllocSetContextCreate(TopMemoryContext, 52. CppAsString(TopPathmanContext), 53. ALLOCSET_DEFAULT_SIZES); 54. 55. PathmanInvalJobsContext = 56. AllocSetContextCreate(TopMemoryContext, 57. CppAsString(PathmanInvalJobsContext), 58. ALLOCSET_SMALL_SIZES); 59. 60. /* For PartRelationInfo */ 61. PathmanRelationCacheContext = 62. AllocSetContextCreate(TopPathmanContext, 63. CppAsString(PathmanRelationCacheContext), 64. ALLOCSET_DEFAULT_SIZES); 65. 66. /* For PartParentInfo */ 67. PathmanParentCacheContext = 68. AllocSetContextCreate(TopPathmanContext, 69. CppAsString(PathmanParentCacheContext), 70. ALLOCSET_DEFAULT_SIZES); 71. 72. /* For PartBoundInfo */ 73. PathmanBoundCacheContext = 74. AllocSetContextCreate(TopPathmanContext, 75. CppAsString(PathmanBoundCacheContext), 76. ALLOCSET_DEFAULT_SIZES); 77. } 78. 79. memset(&ctl, 0, sizeof(ctl)); 80. ctl.keysize = sizeof(Oid); 81. ctl.entrysize = sizeof(PartRelationInfo); 82. ctl.hcxt = PathmanRelationCacheContext; 83. 84. partitioned_rels = hash_create("pg_pathman's partition dispatch cache", 85. PART_RELS_SIZE, &ctl, 86. HASH_ELEM | HASH_BLOBS | HASH_CONTEXT); 87. 88. memset(&ctl, 0, sizeof(ctl)); 89. ctl.keysize = sizeof(Oid); 90. ctl.entrysize = sizeof(PartParentInfo); 91. ctl.hcxt = PathmanParentCacheContext; 92. 93. parent_cache = hash_create("pg_pathman's partition parents cache", 94. PART_RELS_SIZE * CHILD_FACTOR, &ctl, 95. HASH_ELEM | HASH_BLOBS | HASH_CONTEXT); 96. 97. memset(&ctl, 0, sizeof(ctl)); 98. ctl.keysize = sizeof(Oid); 99. ctl.entrysize = sizeof(PartBoundInfo); 100. ctl.hcxt = PathmanBoundCacheContext; 101. 102. bound_cache = hash_create("pg_pathman's partition bounds cache", 103. PART_RELS_SIZE * CHILD_FACTOR, &ctl, 104. HASH_ELEM | HASH_BLOBS | HASH_CONTEXT); 105. }
https://aihuishou.tiancebbs.cn/sh/1574.html https://www.tiancebbs.cn/ershoufang/473080.html https://tz.tiancebbs.cn/qths/450416.html https://www.tiancebbs.cn/ershoufang/468380.html https://taicang.tiancebbs.cn/hjzl/456850.html https://yt.tiancebbs.cn/qcpj/54449.html https://aihuishou.tiancebbs.cn/sh/3975.html https://zulin.tiancebbs.cn/sh/3964.html https://sh.tiancebbs.cn/hjzl/469476.html https://su.tiancebbs.cn/hjzl/457882.html https://su.tiancebbs.cn/hjzl/457900.html https://zulin.tiancebbs.cn/sh/2806.html https://aihuishou.tiancebbs.cn/sh/240.html https://zulin.tiancebbs.cn/sh/1794.html https://www.tiancebbs.cn/ershoufang/473839.html https://www.tiancebbs.cn/ershoufang/467378.html https://zulin.tiancebbs.cn/sh/3698.html
http://yuanbang.tjtcbmw.cn/shuangyashan/ http://bjtcxxw.cn/shanwei/ http://cf.lstcxxw.cn/jiadingqu/ http://gx.lztcxxw.cn/xjbzs/ http://cf.lstcxxw.cn/ahby/ http://bjtcxxw.cn/tjjn/ http://ty.cqtcxxw.cn/hegang/ https://aihuishou.tiancebbs.cn/ftbj/ http://fuyang.tjtcbmw.cn/beijing/ https://tuyang.tiancebbs.cn/ http://ruanwen.xztcxxw.cn/sxbj/ https://chuxiongshi.tiancebbs.cn/ http://huilong.sctcbmw.cn/ningbo/ http://fuyang.tjtcbmw.cn/bnq/ http://shenghuo.china-bbs.com/xjtlf/ http://nalei.zjtcbmw.cn/ysqz/ http://huilong.sctcbmw.cn/sxxz/
cf名字好听的:https://www.nanss.com/mingcheng/5791.html 爱情美文:https://www.nanss.com/yuedu/5118.html 秋天的声音仿写三年级:https://www.nanss.com/xuexi/5258.html 情商高有内涵的网名:https://www.nanss.com/mingcheng/5292.html 午后阳光的句子:https://www.nanss.com/xuexi/5851.html 七夕下雨的说说:https://www.nanss.com/wenan/5724.html 高情商女人发朋友圈吸引男人:https://www.nanss.com/wenan/5573.html 最经典八字静心禅语:https://www.nanss.com/yulu/5999.html 网游女角色名字:https://www.nanss.com/mingcheng/5876.html 开学鼓励孩子的一句话:https://www.nanss.com/xuexi/5357.html 结束语励志的话:https://www.nanss.com/xuexi/5980.html 感谢对手:https://www.nanss.com/xuexi/5026.html 女人自信优雅简短格言:https://www.nanss.com/yulu/5783.html 秋天第一杯奶茶说说:https://www.nanss.com/wenan/4576.html 愚人节说的套路句子:https://www.nanss.com/yulu/5682.html 祝老板生意兴隆的词语:https://www.nanss.com/gongzuo/5923.html 名侦探柯南口头禅:https://www.nanss.com/shenghuo/5047.html 落入凡间的温柔古风句子:https://www.nanss.com/yulu/5945.html 文艺男网名:https://www.nanss.com/mingcheng/5529.html 形容技术很菜的游戏id:https://www.nanss.com/mingcheng/5692.html 绿山墙的安妮读后感:https://www.nanss.com/xuexi/5760.html 孩子玩的开心的说说发朋友圈:https://www.nanss.com/wenan/5858.html 关于星辰的网名:https://www.nanss.com/mingcheng/5793.html 2022昵称大全:https://www.nanss.com/mingcheng/5088.html 带飞字的网名:https://www.nanss.com/mingcheng/5635.html 思念一个人到极致的经典句子:https://www.nanss.com/yulu/5129.html 一句话让别人关注你:https://www.nanss.com/wenan/4493.html 网抑云:https://www.nanss.com/wenti/5099.html 女儿出嫁怎么发朋友圈:https://www.nanss.com/wenan/5785.html 一个人的网名:https://www.nanss.com/mingcheng/5733.html
https://aihuishou.tiancebbs.cn/sh/1574.html https://www.tiancebbs.cn/ershoufang/473080.html https://tz.tiancebbs.cn/qths/450416.html https://www.tiancebbs.cn/ershoufang/468380.html https://taicang.tiancebbs.cn/hjzl/456850.html https://yt.tiancebbs.cn/qcpj/54449.html https://aihuishou.tiancebbs.cn/sh/3975.html https://zulin.tiancebbs.cn/sh/3964.html https://sh.tiancebbs.cn/hjzl/469476.html https://su.tiancebbs.cn/hjzl/457882.html https://su.tiancebbs.cn/hjzl/457900.html https://zulin.tiancebbs.cn/sh/2806.html https://aihuishou.tiancebbs.cn/sh/240.html https://zulin.tiancebbs.cn/sh/1794.html https://www.tiancebbs.cn/ershoufang/473839.html https://www.tiancebbs.cn/ershoufang/467378.html https://zulin.tiancebbs.cn/sh/3698.html
http://yuanbang.tjtcbmw.cn/shuangyashan/ http://bjtcxxw.cn/shanwei/ http://cf.lstcxxw.cn/jiadingqu/ http://gx.lztcxxw.cn/xjbzs/ http://cf.lstcxxw.cn/ahby/ http://bjtcxxw.cn/tjjn/ http://ty.cqtcxxw.cn/hegang/ https://aihuishou.tiancebbs.cn/ftbj/ http://fuyang.tjtcbmw.cn/beijing/ https://tuyang.tiancebbs.cn/ http://ruanwen.xztcxxw.cn/sxbj/ https://chuxiongshi.tiancebbs.cn/ http://huilong.sctcbmw.cn/ningbo/ http://fuyang.tjtcbmw.cn/bnq/ http://shenghuo.china-bbs.com/xjtlf/ http://nalei.zjtcbmw.cn/ysqz/ http://huilong.sctcbmw.cn/sxxz/
cf名字好听的:https://www.nanss.com/mingcheng/5791.html 爱情美文:https://www.nanss.com/yuedu/5118.html 秋天的声音仿写三年级:https://www.nanss.com/xuexi/5258.html 情商高有内涵的网名:https://www.nanss.com/mingcheng/5292.html 午后阳光的句子:https://www.nanss.com/xuexi/5851.html 七夕下雨的说说:https://www.nanss.com/wenan/5724.html 高情商女人发朋友圈吸引男人:https://www.nanss.com/wenan/5573.html 最经典八字静心禅语:https://www.nanss.com/yulu/5999.html 网游女角色名字:https://www.nanss.com/mingcheng/5876.html 开学鼓励孩子的一句话:https://www.nanss.com/xuexi/5357.html 结束语励志的话:https://www.nanss.com/xuexi/5980.html 感谢对手:https://www.nanss.com/xuexi/5026.html 女人自信优雅简短格言:https://www.nanss.com/yulu/5783.html 秋天第一杯奶茶说说:https://www.nanss.com/wenan/4576.html 愚人节说的套路句子:https://www.nanss.com/yulu/5682.html 祝老板生意兴隆的词语:https://www.nanss.com/gongzuo/5923.html 名侦探柯南口头禅:https://www.nanss.com/shenghuo/5047.html 落入凡间的温柔古风句子:https://www.nanss.com/yulu/5945.html 文艺男网名:https://www.nanss.com/mingcheng/5529.html 形容技术很菜的游戏id:https://www.nanss.com/mingcheng/5692.html 绿山墙的安妮读后感:https://www.nanss.com/xuexi/5760.html 孩子玩的开心的说说发朋友圈:https://www.nanss.com/wenan/5858.html 关于星辰的网名:https://www.nanss.com/mingcheng/5793.html 2022昵称大全:https://www.nanss.com/mingcheng/5088.html 带飞字的网名:https://www.nanss.com/mingcheng/5635.html 思念一个人到极致的经典句子:https://www.nanss.com/yulu/5129.html 一句话让别人关注你:https://www.nanss.com/wenan/4493.html 网抑云:https://www.nanss.com/wenti/5099.html 女儿出嫁怎么发朋友圈:https://www.nanss.com/wenan/5785.html 一个人的网名:https://www.nanss.com/mingcheng/5733.html