Re: [HACKERS] Highly Variable Planning Times - Mailing list pgsql-hackers

From Andres Freund
Subject Re: [HACKERS] Highly Variable Planning Times
Date
Msg-id 20170419233538.aeg2twag3tb3yi7e@alap3.anarazel.de
Whole thread Raw
In response to Re: [HACKERS] Highly Variable Planning Times  (Michael Malis <michaelmalis2@gmail.com>)
Responses Re: [HACKERS] Highly Variable Planning Times  (Michael Malis <michaelmalis2@gmail.com>)
List 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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Unportable implementation of background worker start
Next
From: Michael Malis
Date:
Subject: Re: [HACKERS] Highly Variable Planning Times