How to avoid the XLog Write to be the performance bottleneck

Поиск
Список
Период
Сортировка
От 范国腾
Тема How to avoid the XLog Write to be the performance bottleneck
Дата
Msg-id 5cc74fe10cb14187a04c8c0035fc9e31@EX01.highgo.com
обсуждение исходный текст
Ответы Re: How to avoid the XLog Write to be the performance bottleneck  (Andres Freund <andres@anarazel.de>)
Список pgsql-admin
Hi, 

We have two postgres nodes(active/standby). The active node and the standby node use the same share disk(GFS2 file
system).

We are doing the performance test in active side:
(1)Now there is no SQL request sending to the standby side.
(2)The active node has 20 sessions and the test tool sends INSERT/UPDATE/SELECT request to them. The call load is very
high.

In active node, we find that the disk IO is very high but the CPU of each postgres process is about 20%. The pstack
resultshows that most of the postgres process is waiting for the XLOG Write Lock. It seems that the XLog write become
thebottleneck of the postgres database.
 

Could you please give any suggestion how to improve it?


=======================================================
[root@highgo1 ~]# pstack 9434
#0  0x00007fd79545b3a7 in semop () from /usr/lib64/libc.so.6
#1  0x0000000000652d01 in PGSemaphoreLock ()
#2  0x00000000006ab314 in LWLockAcquireOrWait ()
#3  0x00000000004e1f9d in XLogFlush ()
#4  0x00000000004d9167 in CommitTransaction ()
#5  0x00000000004d9bd5 in CommitTransactionCommand ()
#6  0x00000000006b9ff5 in finish_xact_command.part.4 ()
#7  0x00000000006bdd6a in PostgresMain ()
#8  0x0000000000477276 in ServerLoop ()
#9  0x0000000000664186 in PostmasterMain ()
#10 0x0000000000478172 in main ()

The recovery.conf in standby side is :
standby_mode = on
recovery_target_timeline = 'latest'
primary_conninfo = 'host=192.168.100.104 port=5866 user=repuser password=repuser1 application_name=node1'
primary_slot_name = 'slot1'

Thanks
Steven

Вложения

В списке pgsql-admin по дате отправления:

Предыдущее
От: Prince Pathria
Дата:
Сообщение: Configuration changes with multiple standby nodes
Следующее
От: Prince Pathria
Дата:
Сообщение: Fetching postgresql10.5 metrics