Re: Highly Variable Planning Times

From: Andres Freund <andres(at)anarazel(dot)de>
To: Michael Malis <michaelmalis2(at)gmail(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Highly Variable Planning Times
Date: 2017-04-19 23:35:38
Message-ID: 20170419233538.aeg2twag3tb3yi7e@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2017-04-19 14:14:54 -0700, Michael Malis wrote:
> > Could you also get a profile using perf record -g? The strace isn't
> > telling us all that much.
>
> I've attached the perf.data file from `perf record -g -p
> <backend-pid>`. I'm not that familiar with perf so if there is more
> information you need let me know. This was on Ubuntu 16.04

The profile seems to confirm that this is largely due to cache misses.

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Malis 2017-04-19 23:43:07 Re: Highly Variable Planning Times
Previous Message Tom Lane 2017-04-19 22:56:26 Re: Unportable implementation of background worker start