hello everyone:
I was bothered by the postgres spinlock for a long time . How to
understand this sentence "postgres 9.5 performance improvements for multi-CPU
machines"
at present my database is 9.3.5 。 Can it solve the spinlock problem, if
upgrade it to 9.5 ?
there THP problem in it ?
657985...@qq.com
From: Tom Lane
Date: 2015-11-25 10:21
To: 657985...@qq.com
CC: Kevin Grittner; Merlin Moncure; Bill Moran; pgsql-general
Subject: Re: [GENERAL] ??: postgres cpu 100% need help
"657985...@qq.com" <657985...@qq.com> writes:
> thanks for
hi kevin:
thanks for you help . but the following config Indicate my OS THP is Disable
[root@pg1 ~]# grep -i HugePages_Total /proc/meminfo
HugePages_Total: 0
[root@pg1 ~]# cat /proc/sys/vm/nr_hugepages
0
657985...@qq.com
From: Kevin Grittner
Date: 2015-11-23 23:30
To: 657985...@qq.com
0 active connect during load even.every query cost 2000 ms+.
how can I Capture backtrace during load even?
[root@pg1 ~]# cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
[root@pg1 ~]# cat /sys/kernel/mm/transparent_hugepage/defrag
[always] madvise never
657985...@qq.com
Fr
from
tshow.p_hpart_liveingroomlist_count($1)","parameters: $1 = '46'
thanks
657985...@qq.com
发件人： 657985...@qq.com
发送时间： 2015-10-28 16:53
收件人： John R Pierce; pgsql-general
主题： Re: Re: [GENERAL] Re: Re: [GENERAL] 回复: postgres cpu 100% need help
thanks , I can change the sql . Needed a lit
from
tshow.p_hpart_liveingroomlist_count($1)","parameters: $1 = '46'
657985...@qq.com
发件人： John R Pierce
发送时间： 2015-10-28 16:28
收件人： pgsql-general
主题： Re: [GENERAL] Re: Re: [GENERAL] 回复: postgres cpu 100% need help
On 10/28/2015 12:12 AM, 657985...@qq.com wrote:
Thank you for your reply.
300.237 ms execute :
SELECT o_count FROM
tshow.p_hpart_getcount_intitle($1)","parameters: $1 = '46'",,,,""
657985...@qq.com
发件人： Jeff Janes
发送时间： 2015-10-28 03:33
收件人： 657985...@qq.com
抄送： pgsql-general
主
t=1689.86..1689.86 rows=3793 width=64)
-> Seq Scan on res_room_weight t (cost=0.00..1689.86 rows=3793
width=64)
Filter: (subcatlg_id = 46)
4. next i will use perf top to capture during load is essential
657985...@qq.com
From: Merlin Moncure
Date: 2015-10-28 0
tshow=> select count(*) from tshow.res_room_weight ;
count
---
23417
i don't see any Exclusive lock in pg_lock view .
657985...@qq.com
From: Bill Moran
Date: 2015-10-28 01:14
To: 657985...@qq.com
CC: pgsql-general
Subject: Re: [GENERAL]??: postgres cpu 100% need help
On Tue,
r_process | 1000
work_mem | 20MB
shared_buffers | 25GB
Are those problems with the configuration?
qijia.w...@melot.cn
发件人： 657985...@qq.com
发送时间： 2015-10-26 16:14
收件人： 王祺佳
主题： postgres cpu 100
10 matches
Mail list logo
