| From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
|---|---|
| To: | Metin Doslu <metin(at)citusdata(dot)com> |
| Cc: | Claudio Freire <klaussfreire(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Parallel Select query performance and shared buffers |
| Date: | 2013-12-04 16:54:10 |
| Message-ID: | 20131204165410.GA7286@awork2.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On 2013-12-04 18:43:35 +0200, Metin Doslu wrote:
> > I'd strongly suggest doing a "perf record -g -a <wait a bit, ctrl-c>;
> > perf report" run to check what's eating up the time.
>
> Here is one example:
>
> + 38.87% swapper [kernel.kallsyms] [k] hypercall_page
> + 9.32% postgres [kernel.kallsyms] [k] hypercall_page
> + 6.80% postgres [kernel.kallsyms] [k] xen_set_pte_at
All that time is spent in your virtualization solution. One thing to try
is to look on the host system, sometimes profiles there can be more
meaningful.
Greetings,
Andres Freund
--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2013-12-04 17:00:07 | Re: Proposed feature: Selective Foreign Keys |
| Previous Message | Andrew Dunstan | 2013-12-04 16:44:58 | Re: Proposed feature: Selective Foreign Keys |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Claudio Freire | 2013-12-04 18:00:40 | Re: Parallel Select query performance and shared buffers |
| Previous Message | Metin Doslu | 2013-12-04 16:43:35 | Re: Parallel Select query performance and shared buffers |