From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Hubert Lubaczewski <depesz(at)depesz(dot)com> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: swarm of processes in BIND state? |
Date: | 2016-05-28 05:46:52 |
Message-ID: | CAFj8pRC7X-rYkH=pmiFudv9P_K0215Be3x5rVZqqsb7y_dVAjQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
2016-05-28 7:45 GMT+02:00 hubert depesz lubaczewski <depesz(at)depesz(dot)com>:
> On Sat, May 28, 2016 at 07:25:18AM +0200, Pavel Stehule wrote:
> > It is looking like spinlock issue.
> > try to look there by "perf top"
>
> First results look like:
>
> Samples: 64K of event 'cpu-clock', Event count (approx.): 2394094576
>
>
> [0/65]
> 32.08% [unknown] [.] 0x00007f27ed20a296
> 6.31% [kernel] [k] finish_task_switch
> 5.72% [kernel] [k] _raw_spin_unlock_irqrestore
> 3.46% postgres [.] 0x00000000002764ec
> 3.38% libruby-2.1.so.2.1.0 [.] 0x000000000008a8d0
> 2.76% [kernel] [k] __do_page_fault
> 2.08% postgres [.] hash_search_with_hash_value
> 1.94% libc-2.19.so [.] 0x0000000000160b96
> 1.79% postgres [.] LWLockAcquire
> 1.50% postgres [.] heap_page_prune_opt
> 1.28% postgres [.] LWLockRelease
> 1.09% postgres [.] heap_hot_search_buffer
> 1.00% [kernel] [k] tick_nohz_idle_enter
>
> I guess I have to use pg with debugging flags?
>
you should to install debug info - or compile with dubug symbols
Pavel
>
> Best regards,
>
> depesz
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2016-05-28 06:03:51 | Re: swarm of processes in BIND state? |
Previous Message | hubert depesz lubaczewski | 2016-05-28 05:45:28 | Re: swarm of processes in BIND state? |