a8849516

[其他问题] PGSQL用一段时间就卡死

服务器放了多个tomacat.过了10来天这样,每天晚上12点15PGSQL准时卡死,半天都重启不了

。重装PGSQL后还原数据,问题解决,过个10来提案又出现同样问题

换服务器还是这样情况


2019-12-15 00:15:39 HKT LOG:  checkpoints are occurring too frequently (21 seconds apart) 2019-12-15 00:15:39 HKT HINT:  Consider increasing the configuration parameter "checkpoint_segments". 2019-12-15 00:15:54 HKT LOG:  checkpoints are occurring too frequently (15 seconds apart) 2019-12-15 00:15:54 HKT HINT:  Consider increasing the configuration parameter "checkpoint_segments". 2019-12-15 00:16:09 HKT LOG:  checkpoints are occurring too frequently (15 seconds apart) 2019-12-15 00:16:09 HKT HINT:  Consider increasing the configuration parameter "checkpoint_segments".



调整了checkpoint_segments还是这样情况

#wal_level = minimal            # minimal, archive, or hot_standby                    # (change requires restart) #fsync = on             # turns forced synchronization on or off #synchronous_commit = on        # synchronization level;                    # off, local, remote_write, or on #wal_sync_method = fsync        # the default is the first option                    # supported by the operating system:                    #   open_datasync                    #   fdatasync (default on Linux)                    #   fsync                    #   fsync_writethrough                    #   open_sync #full_page_writes = on          # recover from partial page writes #wal_buffers = -1           # min 256kB, -1 sets based on shared_buffers                    # (change requires restart) #wal_writer_delay = 200ms       # 1-10000 milliseconds #commit_delay = 0           # range 0-100000, in microseconds #commit_siblings = 5            # range 1-1000 # - Checkpoints - #checkpoint_segments = 32       # in logfile segments, min 1, 16MB each #checkpoint_timeout = 15min     # range 30s-1h #checkpoint_completion_target = 0.9 # checkpoint target duration, 0.0 - 1.0 #checkpoint_warning = 30s       # 0 disables # - Archiving - #archive_mode = off     # allows archiving to be done                # (change requires restart) #archive_command = ''       # command to use to archive a logfile segment                # placeholders: %p = path of file to archive                #               %f = file name only                # e.g. 'test ! -f /mnt/server/archivedir/%f && cp %p /mnt/server/archivedir/%f' #archive_timeout = 0        # force a logfile segment switch after this                # number of seconds; 0 disables #------------------------------------------------------------------------------


# QUERY TUNING #------------------------------------------------------------------------------ # - Planner Method Configuration - #enable_bitmapscan = on #enable_hashagg = on #enable_hashjoin = on #enable_indexscan = on #enable_indexonlyscan = on #enable_material = on #enable_mergejoin = on #enable_nestloop = on #enable_seqscan = on #enable_sort = on #enable_tidscan = on # - Planner Cost Constants - #seq_page_cost = 1.0            # measured on an arbitrary scale #random_page_cost = 4.0         # same scale as above #cpu_tuple_cost = 0.01          # same scale as above #cpu_index_tuple_cost = 0.005       # same scale as above #cpu_operator_cost = 0.0025     # same scale as above #effective_cache_size = 2GB # - Genetic Query Optimizer - #geqo = on #geqo_threshold = 12 #geqo_effort = 5            # range 1-10 #geqo_pool_size = 0         # selects default based on effort #geqo_generations = 0           # selects default based on effort #geqo_selection_bias = 2.0      # range 1.5-2.0 #geqo_seed = 0.0            # range 0.0-1.0 # - Other Planner Options - #default_statistics_target = 100    # range 1-10000 #constraint_exclusion = partition   # on, off, or partition #cursor_tuple_fraction = 0.1        # range 0.0-1.0 #from_collapse_limit = 8 #join_collapse_limit = 8        # 1 disables collapsing of explicit                    # JOIN clauses #------

#1楼
发帖时间:9月前   |   查看数:0   |   回复数:3
toshow
win?为啥要放多个tomacat?centos表示用的还好
9月前 #2楼
a8849516
多开TOCACAT重启一个不影响别的啊
9月前 #3楼
toshow
为啥要放多个tomacat?centos表示用的还好
6月前 #4楼
游客组