IdentifiantMot de passe
Loading...
Mot de passe oublié ?Je m'inscris ! (gratuit)
Navigation

Inscrivez-vous gratuitement
pour pouvoir participer, suivre les réponses en temps réel, voter pour les messages, poser vos propres questions et recevoir la newsletter

Administration PostgreSQL Discussion :

out of memory postgresql


Sujet :

Administration PostgreSQL

  1. #1
    Membre éprouvé
    Profil pro
    Inscrit en
    Janvier 2007
    Messages
    1 716
    Détails du profil
    Informations personnelles :
    Localisation : France, Alpes Maritimes (Provence Alpes Côte d'Azur)

    Informations forums :
    Inscription : Janvier 2007
    Messages : 1 716
    Par défaut out of memory postgresql
    Bonjour

    J'ai un serveur PostgresSQL11 qui rencontre un Pb, les logs de POSTGRES sont vide par contre le syslog UNIX me donne cela ?
    Une idee comment trquer le OUTOFMEMORY qui à provoqué un KILL par POSTGRESQL
    C'est une VMdédié avec 12Go RAM
    Merci

    Code : Sélectionner tout - Visualiser dans une fenêtre à part
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    40
    41
    42
    43
    44
    45
    46
    47
    48
    49
    50
    51
    52
    53
    54
    55
    56
    57
    58
    59
    60
    61
    62
    63
    64
    65
    66
    67
    68
    69
    70
    71
    72
    73
    74
    75
    76
    77
    78
    79
    80
    81
    82
    83
    84
    85
    86
    87
    88
    89
    90
    91
    92
    93
    94
    95
    96
    97
    98
    99
    100
    101
    102
    103
    104
    105
    106
    107
    108
    109
    110
    111
    112
    113
    114
    115
    116
    117
    118
    119
    120
    121
    122
    123
    124
    125
    126
    127
    128
    129
    130
    131
    132
    133
    134
    135
    136
    137
    138
    139
    140
    141
    142
    143
    144
    145
    146
    147
    148
    149
    150
    151
    152
    153
    154
    155
    156
    157
    158
    159
    160
    161
    162
    163
    164
    165
    166
    167
    168
    169
    170
    171
    172
    173
    174
    175
    176
    177
    178
    179
    180
    181
    182
    183
    184
    185
    186
    187
    188
    189
    190
    191
    192
    193
    194
    195
    196
    197
    198
    199
    200
    201
    202
    203
    204
    205
    206
    207
    208
    209
    210
    211
    212
    213
    214
    215
    216
    217
    218
    219
    220
    221
    222
    223
    224
    225
    226
    227
    228
    229
    230
    231
    232
    233
    234
    235
    236
    237
    238
    239
    240
    241
    242
    243
    244
    245
    246
    247
    248
    249
    250
    251
    252
    253
    254
    255
    256
    257
    258
    259
    260
    261
    262
    263
    264
    265
    266
    267
    268
    269
    270
    271
    272
    273
    274
    275
    276
    277
    278
    279
    280
    281
    282
    283
    284
    285
    286
    287
    288
    289
    290
    291
    292
    293
    294
    295
    296
    297
    298
    299
    300
    301
    302
    303
    304
    305
    306
    307
    308
    309
    310
    311
    312
    313
    314
    315
    316
    317
    318
    319
    320
    321
    322
    323
    324
    325
    326
    327
    328
    329
    330
    331
    332
    333
    334
    335
    336
    337
    338
    339
    340
    341
    342
    343
    344
    345
    346
     
     
     
    May 25 10:55:01 pgsqlm-prod CRON[9373]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446520] postgres invoked oom-killer: gfp_mask=0x24201ca, order=0, oom_score_adj=0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446523] postgres cpuset=/ mems_allowed=0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446529] CPU: 0 PID: 12194 Comm: postgres Not tainted 4.4.0-142-generic #168-Ubuntu
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446530] Hardware name: VMware, Inc. VMware Virtual Platform/440BX Desktop Reference Platform, BIOS 6.00 09/30/2014
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446532]  0000000000000286 19f1444032af8dcb ffff8801170779e8 ffffffff8140a2e1
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446534]  ffff880117077ba0 ffff88032b96f000 ffff880117077a58 ffffffff81217e9e
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446536]  ffff880117077a08 ffffffff81147eaa ffff880117077a88 ffffffff811b0896
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446539] Call Trace:
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446546]  [<ffffffff8140a2e1>] dump_stack+0x63/0x82
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446551]  [<ffffffff81217e9e>] dump_header+0x5a/0x1c3
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446554]  [<ffffffff81147eaa>] ? __delayacct_freepages_end+0x2a/0x30
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446559]  [<ffffffff811b0896>] ? do_try_to_free_pages+0x2a6/0x3b0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446562]  [<ffffffff8119bfae>] oom_kill_process+0x1fe/0x3c0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446564]  [<ffffffff8119c3d9>] out_of_memory+0x219/0x460
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446567]  [<ffffffff811a23f3>] __alloc_pages_slowpath.constprop.88+0x943/0xaf0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446570]  [<ffffffff811a2828>] __alloc_pages_nodemask+0x288/0x2a0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446574]  [<ffffffff811edf2c>] alloc_pages_current+0x8c/0x110
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446576]  [<ffffffff8119842b>] __page_cache_alloc+0xab/0xc0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446578]  [<ffffffff8119aa20>] filemap_fault+0x160/0x440
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446582]  [<ffffffff812b0d16>] ext4_filemap_fault+0x36/0x50
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446585]  [<ffffffff811c8187>] __do_fault+0x77/0x110
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446587]  [<ffffffff811cc143>] handle_mm_fault+0x1273/0x1b80
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446590]  [<ffffffff8185c601>] ? __schedule+0x301/0x810
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446592]  [<ffffffff8185c60d>] ? __schedule+0x30d/0x810
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446593]  [<ffffffff8185c601>] ? __schedule+0x301/0x810
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446595]  [<ffffffff8185c60d>] ? __schedule+0x30d/0x810
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446596]  [<ffffffff8185c601>] ? __schedule+0x301/0x810
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446598]  [<ffffffff8185c601>] ? __schedule+0x301/0x810
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446602]  [<ffffffff8106dd44>] __do_page_fault+0x1a4/0x410
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446604]  [<ffffffff8106dfd2>] do_page_fault+0x22/0x30
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446608]  [<ffffffff81864028>] page_fault+0x28/0x30
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446609] Mem-Info:
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446614] active_anon:2502873 inactive_anon:409764 isolated_anon:0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446614]  active_file:92 inactive_file:41 isolated_file:0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446614]  unevictable:913 dirty:0 writeback:0 unstable:0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446614]  slab_reclaimable:15596 slab_unreclaimable:7567
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446614]  mapped:1094244 shmem:1077268 pagetables:68763 bounce:0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446614]  free:30342 free_pcp:475 free_cma:0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446617] Node 0 DMA free:15856kB min:84kB low:104kB high:124kB active_anon:0kB inactive_anon:0kB active_file:0kB inactive_file:0kB unevictable:0kB isolated(anon):0kB isolated(file):0kB present:15992kB managed:15904kB mlocked:0kB dirty:0kB writeback:0kB mapped:0kB shmem:0kB slab_reclaimable:0kB slab_unreclaimable:16kB kernel_stack:0kB pagetables:0kB unstable:0kB bounce:0kB free_pcp:0kB local_pcp:0kB free_cma:0kB writeback_tmp:0kB pages_scanned:0 all_unreclaimable? yes
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446623] lowmem_reserve[]: 0 2935 11957 11957 11957
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446626] Node 0 DMA32 free:52636kB min:16564kB low:20704kB high:24844kB active_anon:2291224kB inactive_anon:593744kB active_file:148kB inactive_file:4kB unevictable:396kB isolated(anon):0kB isolated(file):0kB present:3129280kB managed:3048404kB mlocked:396kB dirty:8kB writeback:0kB mapped:1074460kB shmem:1057576kB slab_reclaimable:15076kB slab_unreclaimable:5872kB kernel_stack:1200kB pagetables:58504kB unstable:0kB bounce:0kB free_pcp:944kB local_pcp:104kB free_cma:0kB writeback_tmp:0kB pages_scanned:3136 all_unreclaimable? yes
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446631] lowmem_reserve[]: 0 0 9022 9022 9022
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446633] Node 0 Normal free:52876kB min:50928kB low:63660kB high:76392kB active_anon:7720268kB inactive_anon:1045312kB active_file:220kB inactive_file:160kB unevictable:3256kB isolated(anon):0kB isolated(file):0kB present:9437184kB managed:9239272kB mlocked:3256kB dirty:0kB writeback:0kB mapped:3302516kB shmem:3251496kB slab_reclaimable:47308kB slab_unreclaimable:24380kB kernel_stack:2768kB pagetables:216548kB unstable:0kB bounce:0kB free_pcp:1024kB local_pcp:28kB free_cma:0kB writeback_tmp:0kB pages_scanned:4308 all_unreclaimable? yes
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446638] lowmem_reserve[]: 0 0 0 0 0
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446640] Node 0 DMA: 0*4kB 0*8kB 1*16kB (U) 1*32kB (U) 1*64kB (U) 1*128kB (U) 1*256kB (U) 0*512kB 1*1024kB (U) 1*2048kB (M) 3*4096kB (M) = 15856kB
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446649] Node 0 DMA32: 187*4kB (UE) 358*8kB (UME) 3067*16kB (UME) 1*32kB (U) 0*64kB 0*128kB 0*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 52716kB
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446657] Node 0 Normal: 242*4kB (UE) 6223*8kB (UME) 1*16kB (M) 0*32kB 0*64kB 0*128kB 0*256kB 0*512kB 0*1024kB 1*2048kB (H) 0*4096kB = 52816kB
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446665] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=1048576kB
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446667] Node 0 hugepages_total=0 hugepages_free=0 hugepages_surp=0 hugepages_size=2048kB
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446668] 1080812 total pagecache pages
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446669] 2598 pages in swap cache
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446671] Swap cache stats: add 3319061, delete 3316463, find 141797301/143247859
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446672] Free swap  = 0kB
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446673] Total swap = 998396kB
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446674] 3145614 pages RAM
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446675] 0 pages HighMem/MovableOnly
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446676] 69719 pages reserved
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446676] 0 pages cma reserved
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446677] 0 pages hwpoisoned
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446678] [ pid ]   uid  tgid total_vm      rss nr_ptes nr_pmds swapents oom_score_adj name
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446683] [  396]     0   396    13019      486      27       3      583             0 systemd-journal
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446686] [  433]     0   433    25742       93      17       3       45             0 lvmetad
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446688] [  481]     0   481    30179      134      52       3      271             0 vmtoolsd
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446690] [  490]     0   490    11437      373      23       3      537         -1000 systemd-udevd
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446692] [  506]   100   506    25081      182      19       3       45             0 systemd-timesyn
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446694] [  930]     0   930     7252      438      20       3       48             0 cron
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446696] [  932]   104   932    64098      321      26       3      323             0 rsyslogd
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446699] [  942]     0   942     7156      421      19       3       40             0 systemd-logind
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446701] [  946]     0   946     1099      282       8       3       31             0 acpid
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446703] [  948]     0   948    21360      343      33       3      341             0 VGAuthService
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446705] [  953]     0   953   114111      325      23       4       76             0 lxcfs
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446707] [  955]     0   955     6511      303      17       3       45             0 atd
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446709] [  957]   107   957    10737      458      25       3       76          -900 dbus-daemon
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446711] [ 1037]     0  1037    43649      405      53       3     2025             0 unattended-upgr
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446713] [ 1069]     0  1069     3343       12      11       3       23             0 mdadm
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446715] [ 1071]     0  1071     1305       12       8       3       16             0 iscsid
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446717] [ 1072]     0  1072     1430      877       8       3        0           -17 iscsid
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446719] [ 1171]     0  1171     3984      308      13       3       27             0 agetty
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446721] [ 1189]     0  1189     4905      370      13       3       40             0 irqbalance
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446724] [ 1257]     0  1257    16378      450      35       3      152         -1000 sshd
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446726] [ 2276]     0  2276     1126      268       8       3       26             0 connectwisecont
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446728] [ 2531]     0  2531    69272      325      40       3       97             0 polkitd
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446730] [21694]   111 21694  1175099    27470     174       4      284          -900 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446732] [21696]   111 21696  1175170   744741    1920       7      292             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446734] [21697]   111 21697  1175133    61810    1178       7      291             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446736] [21698]   111 21698  1175099     4414      73       4      291             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446738] [21699]   111 21699  1175251      472      78       4      338             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446740] [21700]   111 21700    41450      363      62       4      292             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446742] [21701]   111 21701    41526      258      62       4      294             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446744] [21702]   111 21702  1175201      634      72       4      346             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446746] [ 2353]     0  2353    75420     1948      49       3     4724             0 accounts-daemon
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446748] [ 7076]   111  7076  1175435     1180      88       4      429             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446750] [12181]   111 12181  1175377     1801     105       4      501             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446752] [12182]   111 12182  1175377     1800     106       4      502             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446754] [12183]   111 12183  1175377     1801     105       4      501             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446756] [12184]   111 12184  1175377     1801     105       4      501             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446758] [12185]   111 12185  1175377     1817     106       4      501             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446760] [12186]   111 12186  1175377     1815     105       4      489             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446762] [12187]   111 12187  1175377     1845     105       4      458             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446764] [12188]   111 12188  1175377     1834     106       4      453             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446766] [12189]   111 12189  1175377     1844     106       4      486             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446768] [12190]   111 12190  1175377     1806     105       4      497             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446770] [12191]   111 12191  1235517   314367    1696       8      277             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446772] [12192]   111 12192  1175827     7392     153       7      320             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446774] [12193]   111 12193  1224734   431022    1928       7      279             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446776] [12194]   111 12194  1231269   310780    1704       7      279             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446778] [12195]   111 12195  1175918    18096     306       7      305             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446780] [12196]   111 12196  1235787   322215    1722       8      279             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446782] [12197]   111 12197  1177143    15804     244       7      301             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446783] [12198]   111 12198  1228391   397450    1898       7      282             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446785] [12199]   111 12199  1176604    45970     388       7      312             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446787] [12200]   111 12200  1236042   293914    1758       8      280             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446789] [12201]   111 12201  1176143    15814     259       7      303             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446791] [12202]   111 12202  1233841   500692    2072       8      281             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446794] [12203]   111 12203  1177219    16229     255       7      299             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446795] [12204]   111 12204  1177263    18379     268       7      303             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446797] [12205]   111 12205  1176111    15947     278       7      307             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446799] [12206]   111 12206  1176860    15670     252       7      300             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446801] [12207]   111 12207  1230858   335646    1697       7      280             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446803] [12208]   111 12208  1177072    57366     449       7      290             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446805] [12209]   111 12209  1175918    18067     287       7      305             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446807] [12210]   111 12210  1177264    17098     251       7      300             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446809] [12211]   111 12211  1252121   624492    2191       8      279             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446811] [12212]   111 12212  1175873    15441     254       7      305             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446813] [12213]   111 12213  1252238   763224    2253       8      279             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446815] [12214]   111 12214  1255322  1154711    2371       8      334             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446817] [12215]   111 12215  1254717  1154631    2370       8      332             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446819] [12216]   111 12216  1251856  1148602    2364       8     3899             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446821] [12217]   111 12217  1255770  1154353    2371       8      841             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446823] [12218]   111 12218  1253125  1148056    2367       8     5662             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446825] [12219]   111 12219  1254521  1117426    2341       8     1927             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446827] [12220]   111 12220  1255969  1150960    2372       8     5245             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446829] [12221]   111 12221  1255435  1152086    2371       8     3893             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446831] [12222]   111 12222  1256178  1149855    2373       8     7013             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446833] [12223]   111 12223  1254411  1112189    2369       8    43035             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446835] [12224]   111 12224  1254143  1129288    2369       8    24819             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446837] [12225]   111 12225  1253160  1143294    2367       8    10591             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446839] [12226]   111 12226  1252970  1064317    2364       8    14959             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446841] [12227]   111 12227  1255765  1146928    2372       8     9336             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446842] [12228]   111 12228  1260272  1149885    2381       8    10731             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446844] [12229]   111 12229  1255792  1139320    2371       8    15462             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446846] [12230]   111 12230  1261673  1156422    2382       8     4569             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446849] [ 1459]     0  1459    17795      544      28       3      910             0 s1-orchestrator
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446851] [ 1460]   999  1460   162697     1751      54       4      954             0 s1-network
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446853] [ 1461]     0  1461    96610     9980      84       3     9114             0 s1-scanner
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446855] [ 1463]   999  1463   451355    35020     193       6     9845             0 s1-agent
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446857] [ 1464]     0  1464    38635      699      31       3      933             0 s1-firewall
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446858] [ 1465]     0  1465    91899      691      37       3      931             0 s1-fanotify
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446860] [ 1466]     0  1466   126812    18590      75       4     1059             0 s1-perf
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446862] [28867]   111 28867  1175411     5370     116       6      245             0 postgres
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446865] [10019]     0 10019     1822       65       9       3        0             0 sleep
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.446866] Out of memory: Kill process 12230 (postgres) score 349 or sacrifice child
    May 25 10:59:51 pgsqlm-prod kernel: [3072883.447951] Killed process 12230 (postgres) total-vm:5046692kB, anon-rss:319384kB, file-rss:4306304kB
    May 25 11:05:02 pgsqlm-prod CRON[10356]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 11:15:01 pgsqlm-prod CRON[11732]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 11:17:02 pgsqlm-prod CRON[11902]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 11:25:01 pgsqlm-prod CRON[12853]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 11:32:03 pgsqlm-prod systemd[1]: Starting Message of the Day...
    May 25 11:32:05 pgsqlm-prod 50-motd-news[13929]:  * Super-optimized for small spaces - read how we shrank the memory
    May 25 11:32:05 pgsqlm-prod 50-motd-news[13929]:    footprint of MicroK8s to make it the smallest full K8s around.
    May 25 11:32:05 pgsqlm-prod 50-motd-news[13929]:    https://ubuntu.com/blog/microk8s-memory-optimisation
    May 25 11:32:05 pgsqlm-prod systemd[1]: Started Message of the Day.
    May 25 11:35:01 pgsqlm-prod CRON[14372]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 11:45:01 pgsqlm-prod CRON[15763]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 11:55:01 pgsqlm-prod CRON[17089]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 12:05:01 pgsqlm-prod CRON[18104]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 12:15:01 pgsqlm-prod CRON[18701]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 12:17:01 pgsqlm-prod CRON[18788]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 12:25:01 pgsqlm-prod CRON[19213]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 12:35:01 pgsqlm-prod CRON[19735]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 12:45:01 pgsqlm-prod CRON[20384]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 12:55:01 pgsqlm-prod CRON[21076]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 13:05:01 pgsqlm-prod CRON[22203]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 13:15:01 pgsqlm-prod CRON[23424]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 13:17:01 pgsqlm-prod CRON[23611]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 13:25:01 pgsqlm-prod CRON[24725]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 13:35:01 pgsqlm-prod CRON[25985]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 13:45:01 pgsqlm-prod CRON[27384]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 13:55:01 pgsqlm-prod CRON[28613]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 14:05:01 pgsqlm-prod CRON[30229]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 14:15:01 pgsqlm-prod CRON[31443]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 14:17:01 pgsqlm-prod CRON[31826]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 14:25:01 pgsqlm-prod CRON[486]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 14:35:01 pgsqlm-prod CRON[2001]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 14:45:01 pgsqlm-prod CRON[3234]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 14:55:01 pgsqlm-prod CRON[4453]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 15:05:01 pgsqlm-prod CRON[5488]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 15:15:01 pgsqlm-prod CRON[6886]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 15:17:01 pgsqlm-prod CRON[7141]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 15:25:01 pgsqlm-prod CRON[8321]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 15:35:01 pgsqlm-prod CRON[9419]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 15:45:01 pgsqlm-prod CRON[10916]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 15:55:01 pgsqlm-prod CRON[12341]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 16:05:01 pgsqlm-prod CRON[13516]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 16:15:01 pgsqlm-prod CRON[14761]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 16:17:01 pgsqlm-prod CRON[14895]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 16:25:01 pgsqlm-prod CRON[15804]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 16:35:01 pgsqlm-prod CRON[16985]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 16:45:01 pgsqlm-prod CRON[18099]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 16:55:01 pgsqlm-prod CRON[18984]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 17:05:01 pgsqlm-prod CRON[19629]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 17:15:01 pgsqlm-prod CRON[20261]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 17:17:01 pgsqlm-prod CRON[20331]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 17:25:01 pgsqlm-prod CRON[20681]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 17:35:01 pgsqlm-prod CRON[21196]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 17:45:01 pgsqlm-prod CRON[21634]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 17:55:01 pgsqlm-prod CRON[22135]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 18:05:01 pgsqlm-prod CRON[22592]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 18:15:01 pgsqlm-prod CRON[22974]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 18:17:01 pgsqlm-prod CRON[23049]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 18:25:01 pgsqlm-prod CRON[23390]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 18:29:30 pgsqlm-prod systemd[1]: Created slice User Slice of microcomp.
    May 25 18:29:30 pgsqlm-prod systemd[1]: Starting User Manager for UID 1000...
    May 25 18:29:30 pgsqlm-prod systemd[1]: Started Session 8389 of user microcomp.
    May 25 18:29:31 pgsqlm-prod systemd[23589]: Reached target Timers.
    May 25 18:29:31 pgsqlm-prod systemd[23589]: Reached target Sockets.
    May 25 18:29:31 pgsqlm-prod systemd[23589]: Reached target Paths.
    May 25 18:29:31 pgsqlm-prod systemd[23589]: Reached target Basic System.
    May 25 18:29:31 pgsqlm-prod systemd[23589]: Reached target Default.
    May 25 18:29:31 pgsqlm-prod systemd[23589]: Startup finished in 194ms.
    May 25 18:29:31 pgsqlm-prod systemd[1]: Started User Manager for UID 1000.
    May 25 18:29:32 pgsqlm-prod systemd[1]: Started Session 8390 of user microcomp.
    May 25 18:29:44 pgsqlm-prod systemd[1]: Started Session 8391 of user microcomp.
    May 25 18:29:45 pgsqlm-prod kernel: [3099877.601137] blk_update_request: I/O error, dev fd0, sector 0
    May 25 18:29:45 pgsqlm-prod kernel: [3099877.603136] floppy: error -5 while reading block 0
    May 25 18:35:01 pgsqlm-prod CRON[24373]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 18:35:32 pgsqlm-prod systemd[1]: Stopping User Manager for UID 1000...
    May 25 18:35:32 pgsqlm-prod systemd[23589]: Reached target Shutdown.
    May 25 18:35:32 pgsqlm-prod systemd[23589]: Starting Exit the Session...
    May 25 18:35:32 pgsqlm-prod systemd[23589]: Stopped target Default.
    May 25 18:35:32 pgsqlm-prod systemd[23589]: Stopped target Basic System.
    May 25 18:35:32 pgsqlm-prod systemd[23589]: Stopped target Paths.
    May 25 18:35:32 pgsqlm-prod systemd[23589]: Stopped target Timers.
    May 25 18:35:32 pgsqlm-prod systemd[23589]: Stopped target Sockets.
    May 25 18:35:32 pgsqlm-prod systemd[23589]: Received SIGRTMIN+24 from PID 24408 (kill).
    May 25 18:35:32 pgsqlm-prod systemd[1]: Stopped User Manager for UID 1000.
    May 25 18:35:32 pgsqlm-prod systemd[1]: Removed slice User Slice of microcomp.
    May 25 18:45:01 pgsqlm-prod CRON[24833]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 18:55:01 pgsqlm-prod CRON[25245]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 19:05:01 pgsqlm-prod CRON[25659]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 19:15:01 pgsqlm-prod CRON[26097]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 19:17:01 pgsqlm-prod CRON[26182]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 19:25:01 pgsqlm-prod CRON[26452]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 19:35:01 pgsqlm-prod CRON[26881]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 19:45:01 pgsqlm-prod CRON[27314]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 19:55:01 pgsqlm-prod CRON[27683]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 20:05:01 pgsqlm-prod CRON[28119]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 20:15:01 pgsqlm-prod CRON[28518]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 20:17:01 pgsqlm-prod CRON[28583]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 20:25:01 pgsqlm-prod CRON[28907]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 20:35:01 pgsqlm-prod CRON[29343]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 20:38:21 pgsqlm-prod systemd[1]: Starting Message of the Day...
    May 25 20:38:22 pgsqlm-prod 50-motd-news[29491]:  * Super-optimized for small spaces - read how we shrank the memory
    May 25 20:38:22 pgsqlm-prod 50-motd-news[29491]:    footprint of MicroK8s to make it the smallest full K8s around.
    May 25 20:38:22 pgsqlm-prod 50-motd-news[29491]:    https://ubuntu.com/blog/microk8s-memory-optimisation
    May 25 20:38:22 pgsqlm-prod systemd[1]: Started Message of the Day.
    May 25 20:45:01 pgsqlm-prod CRON[29747]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 20:55:01 pgsqlm-prod CRON[30156]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 21:05:01 pgsqlm-prod CRON[30590]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 21:15:01 pgsqlm-prod CRON[30942]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 21:17:01 pgsqlm-prod CRON[31032]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 21:25:01 pgsqlm-prod CRON[31381]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 21:35:01 pgsqlm-prod CRON[31860]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 21:45:01 pgsqlm-prod CRON[32205]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 21:55:01 pgsqlm-prod CRON[32642]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 22:00:01 pgsqlm-prod CRON[392]: (postgres) CMD (pg_dump -U postgres forget_prod | gzip > ~/postgres/backups/forget_prod.gz)
    May 25 22:05:01 pgsqlm-prod CRON[613]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 22:13:40 pgsqlm-prod systemd[1]: Starting Cleanup of Temporary Directories...
    May 25 22:13:40 pgsqlm-prod systemd-tmpfiles[1003]: [/usr/lib/tmpfiles.d/var.conf:14] Duplicate line for path "/var/log", ignoring.
    May 25 22:13:40 pgsqlm-prod systemd[1]: Started Cleanup of Temporary Directories.
    May 25 22:15:01 pgsqlm-prod CRON[1052]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 22:17:01 pgsqlm-prod CRON[1131]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 22:25:01 pgsqlm-prod CRON[1496]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 22:30:01 pgsqlm-prod CRON[1731]: (postgres) CMD (pg_dump -U postgres forget_ramq_prod | gzip > ~/postgres/backups/forget_ramq_prod.gz)
    May 25 22:35:01 pgsqlm-prod CRON[1955]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 22:45:01 pgsqlm-prod CRON[2354]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 22:55:01 pgsqlm-prod CRON[2745]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 23:05:01 pgsqlm-prod CRON[3177]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 23:15:01 pgsqlm-prod CRON[3540]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 23:17:01 pgsqlm-prod CRON[3613]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 25 23:25:01 pgsqlm-prod CRON[3971]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 23:35:01 pgsqlm-prod CRON[4419]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 23:45:01 pgsqlm-prod CRON[4834]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 23:55:01 pgsqlm-prod CRON[5270]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 25 23:59:01 pgsqlm-prod CRON[5442]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 60 2)
    May 26 00:05:01 pgsqlm-prod CRON[5737]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 00:15:01 pgsqlm-prod CRON[6101]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 00:17:01 pgsqlm-prod CRON[6191]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 26 00:25:01 pgsqlm-prod CRON[6539]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 00:35:01 pgsqlm-prod CRON[6959]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 00:45:01 pgsqlm-prod CRON[7329]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 00:55:01 pgsqlm-prod CRON[7765]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 01:05:01 pgsqlm-prod CRON[8172]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 01:15:01 pgsqlm-prod CRON[8569]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 01:17:01 pgsqlm-prod CRON[8660]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 26 01:25:01 pgsqlm-prod CRON[9010]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 01:35:01 pgsqlm-prod CRON[9397]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 01:41:13 pgsqlm-prod systemd[1]: Starting Daily apt download activities...
    May 26 01:41:14 pgsqlm-prod systemd[1]: Started Daily apt download activities.
    May 26 01:45:01 pgsqlm-prod CRON[9821]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 01:55:01 pgsqlm-prod CRON[10265]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 02:05:01 pgsqlm-prod CRON[10634]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 02:15:01 pgsqlm-prod CRON[11066]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 02:17:01 pgsqlm-prod CRON[11155]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 26 02:25:01 pgsqlm-prod CRON[11507]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 02:35:01 pgsqlm-prod CRON[11862]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 02:45:01 pgsqlm-prod CRON[12303]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 02:55:01 pgsqlm-prod CRON[12747]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 03:05:01 pgsqlm-prod CRON[13095]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 03:15:01 pgsqlm-prod CRON[13533]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 03:17:01 pgsqlm-prod CRON[13624]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 26 03:25:01 pgsqlm-prod CRON[13976]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 03:35:01 pgsqlm-prod CRON[14316]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 03:45:01 pgsqlm-prod CRON[14757]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 03:54:46 pgsqlm-prod systemd[1]: Starting Message of the Day...
    May 26 03:54:47 pgsqlm-prod 50-motd-news[15179]:  * Super-optimized for small spaces - read how we shrank the memory
    May 26 03:54:47 pgsqlm-prod 50-motd-news[15179]:    footprint of MicroK8s to make it the smallest full K8s around.
    May 26 03:54:47 pgsqlm-prod 50-motd-news[15179]:    https://ubuntu.com/blog/microk8s-memory-optimisation
    May 26 03:54:47 pgsqlm-prod systemd[1]: Started Message of the Day.
    May 26 03:55:01 pgsqlm-prod CRON[15219]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 04:05:01 pgsqlm-prod CRON[15563]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 04:15:01 pgsqlm-prod CRON[16002]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 04:17:01 pgsqlm-prod CRON[16092]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 26 04:25:01 pgsqlm-prod CRON[16434]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 04:35:01 pgsqlm-prod CRON[16796]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 04:45:01 pgsqlm-prod CRON[17238]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 04:55:01 pgsqlm-prod CRON[17631]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 04:57:01 pgsqlm-prod CRON[17698]: (root) CMD (   test -x /etc/cron.daily/popularity-contest && /etc/cron.daily/popularity-contest --crond)
    May 26 05:05:01 pgsqlm-prod CRON[18087]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 05:15:01 pgsqlm-prod CRON[18529]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 05:17:01 pgsqlm-prod CRON[18624]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 26 05:25:01 pgsqlm-prod CRON[18925]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 05:35:01 pgsqlm-prod CRON[19327]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 05:45:01 pgsqlm-prod CRON[19771]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 05:55:01 pgsqlm-prod CRON[20159]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 06:03:46 pgsqlm-prod systemd[1]: Starting Daily apt upgrade and clean activities...
    May 26 06:03:47 pgsqlm-prod systemd[1]: Started Daily apt upgrade and clean activities.
    May 26 06:05:01 pgsqlm-prod CRON[20595]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 06:15:01 pgsqlm-prod CRON[21032]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)
    May 26 06:17:01 pgsqlm-prod CRON[21124]: (root) CMD (   cd / && run-parts --report /etc/cron.hourly)
    May 26 06:25:01 pgsqlm-prod CRON[21432]: (root) CMD (test -x /usr/sbin/anacron || ( cd / && run-parts --report /etc/cron.daily ))
    May 26 06:25:01 pgsqlm-prod CRON[21434]: (root) CMD (command -v debian-sa1 > /dev/null && debian-sa1 1 1)

  2. #2
    Rédacteur

    Avatar de SQLpro
    Homme Profil pro
    Expert bases de données / SQL / MS SQL Server / Postgresql
    Inscrit en
    Mai 2002
    Messages
    21 998
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France, Var (Provence Alpes Côte d'Azur)

    Informations professionnelles :
    Activité : Expert bases de données / SQL / MS SQL Server / Postgresql
    Secteur : Conseil

    Informations forums :
    Inscription : Mai 2002
    Messages : 21 998
    Billets dans le blog
    6
    Par défaut
    Commencez par vérifier si la VM est pas en "balooning" par hasard....

    A +
    Frédéric Brouard - SQLpro - ARCHITECTE DE DONNÉES - expert SGBDR et langage SQL
    Le site sur les SGBD relationnels et le langage SQL: http://sqlpro.developpez.com/
    Blog SQL, SQL Server, SGBDR : http://blog.developpez.com/sqlpro
    Expert Microsoft SQL Server - M.V.P. (Most valuable Professional) MS Corp.
    Entreprise SQL SPOT : modélisation, conseils, audit, optimisation, formation...
    * * * * * Expertise SQL Server : http://mssqlserver.fr/ * * * * *

  3. #3
    Membre éprouvé
    Profil pro
    Inscrit en
    Janvier 2007
    Messages
    1 716
    Détails du profil
    Informations personnelles :
    Localisation : France, Alpes Maritimes (Provence Alpes Côte d'Azur)

    Informations forums :
    Inscription : Janvier 2007
    Messages : 1 716
    Par défaut
    Ok je vais voir avec lui car je n'ai pas acces à cette partie la
    Mais donc vmware ne doit pas etre en mode Ballooning pour POSTGRESQL ?

  4. #4
    Rédacteur

    Avatar de SQLpro
    Homme Profil pro
    Expert bases de données / SQL / MS SQL Server / Postgresql
    Inscrit en
    Mai 2002
    Messages
    21 998
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France, Var (Provence Alpes Côte d'Azur)

    Informations professionnelles :
    Activité : Expert bases de données / SQL / MS SQL Server / Postgresql
    Secteur : Conseil

    Informations forums :
    Inscription : Mai 2002
    Messages : 21 998
    Billets dans le blog
    6
    Par défaut
    les SGBD sont les systèmes les plus consommateurs de ressources de toutes sorte de tous les logiciels de gestion. Ils ont besoin de mémoire, de stockage et de processeurs pour travailler avec de nombreux utilisateurs simultanés. Les réglages par défaut des VM (VMWare, Xen, Hyper V...) tente d'économiser ces ressources pour les distribuer à d'autres VM. En matière de mémoire cela s’appelle le balooning. Il faut aussi fixer les cœurs utilisé et donc, ne pas accepter des cœurs flottants.

    Pour éviter ce genre de problématique, Oracle à décidé de sa propre virtualisation et ne prend pas en garantie les instances Oracle hébergée sur d'autre VM que la leur.

    Pour SQL Server, même principe : un guide de 82 pages pour les bonnes pratiques sous VM Ware (rarement respecté) et de même pour Hyper V.

    A +
    Frédéric Brouard - SQLpro - ARCHITECTE DE DONNÉES - expert SGBDR et langage SQL
    Le site sur les SGBD relationnels et le langage SQL: http://sqlpro.developpez.com/
    Blog SQL, SQL Server, SGBDR : http://blog.developpez.com/sqlpro
    Expert Microsoft SQL Server - M.V.P. (Most valuable Professional) MS Corp.
    Entreprise SQL SPOT : modélisation, conseils, audit, optimisation, formation...
    * * * * * Expertise SQL Server : http://mssqlserver.fr/ * * * * *

  5. #5
    Membre éprouvé
    Profil pro
    Inscrit en
    Janvier 2007
    Messages
    1 716
    Détails du profil
    Informations personnelles :
    Localisation : France, Alpes Maritimes (Provence Alpes Côte d'Azur)

    Informations forums :
    Inscription : Janvier 2007
    Messages : 1 716
    Par défaut
    Bonjour

    Pour l'instant le client à décidé d'augmenter sa VM de 6Go de mémoire, je ne suis pas sur que cela suffise pour les 250 utilisateurs de POSTGRES 11.5, mais c'est déja cela !
    Bien sur j'ai checké que cela correspond au moins au Preco de Pg tune

    Merci pour vos réponses

  6. #6
    Rédacteur

    Avatar de SQLpro
    Homme Profil pro
    Expert bases de données / SQL / MS SQL Server / Postgresql
    Inscrit en
    Mai 2002
    Messages
    21 998
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Localisation : France, Var (Provence Alpes Côte d'Azur)

    Informations professionnelles :
    Activité : Expert bases de données / SQL / MS SQL Server / Postgresql
    Secteur : Conseil

    Informations forums :
    Inscription : Mai 2002
    Messages : 21 998
    Billets dans le blog
    6
    Par défaut
    Effectivement PostGreSQL bouffe beaucoup de RAM pour chaque connexion, car il n'intègre pas de pooling... Chaque connexion étant maintenue à chaud avec un morceau dédié de la RAM. D'autres SGBDR SQL Server comme Orcle intègrent un pooling interne de manière a économiser la RAM, les utilisateurs n'ayant pas pour habitude d'effectuer 15 000 requêtes par seconde !

    C'est une des différences majeure que j'indique dans cet article (hélas encore en anglais) mais en cours de traduction pour developpez) :
    http://mssqlserver.fr/postgresql-vs-...ed-comparison/
    § 13 – The disastrous user’s number scalability

    A +
    Frédéric Brouard - SQLpro - ARCHITECTE DE DONNÉES - expert SGBDR et langage SQL
    Le site sur les SGBD relationnels et le langage SQL: http://sqlpro.developpez.com/
    Blog SQL, SQL Server, SGBDR : http://blog.developpez.com/sqlpro
    Expert Microsoft SQL Server - M.V.P. (Most valuable Professional) MS Corp.
    Entreprise SQL SPOT : modélisation, conseils, audit, optimisation, formation...
    * * * * * Expertise SQL Server : http://mssqlserver.fr/ * * * * *

  7. #7
    Membre éprouvé
    Profil pro
    Inscrit en
    Janvier 2007
    Messages
    1 716
    Détails du profil
    Informations personnelles :
    Localisation : France, Alpes Maritimes (Provence Alpes Côte d'Azur)

    Informations forums :
    Inscription : Janvier 2007
    Messages : 1 716
    Par défaut
    Merci pour les explications

  8. #8
    Membre émérite

    Homme Profil pro
    Auditeur informatique
    Inscrit en
    Novembre 2014
    Messages
    817
    Détails du profil
    Informations personnelles :
    Sexe : Homme
    Âge : 41
    Localisation : Tunisie

    Informations professionnelles :
    Activité : Auditeur informatique
    Secteur : High Tech - Éditeur de logiciels

    Informations forums :
    Inscription : Novembre 2014
    Messages : 817
    Billets dans le blog
    2
    Par défaut
    il vaut mieux que vous commencer par auditer votre fichier de config postgresql.conf

    Surtout les valeurs de shared_buffer , work_mem mis dans votre fichier de config postgresql.conf

+ Répondre à la discussion
Cette discussion est résolue.

Discussions similaires

  1. [XStream][String]out of memory
    Par Invité dans le forum Persistance des données
    Réponses: 8
    Dernier message: 10/01/2006, 14h52
  2. [C++] [gcc] out of memory
    Par fxp17 dans le forum GCC
    Réponses: 5
    Dernier message: 06/01/2006, 10h29
  3. [pb mémoire] out of memory d'eclipse
    Par Casp dans le forum Eclipse Java
    Réponses: 2
    Dernier message: 12/05/2005, 16h39
  4. Out of memory
    Par shurato dans le forum ANT
    Réponses: 1
    Dernier message: 10/11/2004, 16h19
  5. [JBuilder 8] Out of memory problem ...
    Par keros dans le forum JBuilder
    Réponses: 2
    Dernier message: 08/09/2003, 19h03

Partager

Partager
  • Envoyer la discussion sur Viadeo
  • Envoyer la discussion sur Twitter
  • Envoyer la discussion sur Google
  • Envoyer la discussion sur Facebook
  • Envoyer la discussion sur Digg
  • Envoyer la discussion sur Delicious
  • Envoyer la discussion sur MySpace
  • Envoyer la discussion sur Yahoo