From: Justin Pryzby <pryzby@telsasoft.com>
To: Richard Lee <swift1984@gmail.com>
Cc: tomas.vondra@2ndquadrant.com
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Fwd: Query with high planning time compared to execution time
Date: Sun, 4 Nov 2018 22:10:09 -0600
Message-ID: <20181105041009.GY25283@telsasoft.com> (raw)
In-Reply-To: <CALhvPTRnqLoS-XAo1MAJEGM=0KuxVua_ATmigELh8EtVhqSjxQ@mail.gmail.com>
References: <CALhvPTQJ12d1VEOoekJNt6+zDuSfcubqP3WO47OiUXUVBR3o3g@mail.gmail.com>
<CALhvPTS3XmDa7Px2WdZhyvwHPsqC=KKQ2kTsGL0KZiuwGF8C4g@mail.gmail.com>
<8db7abc2-9ddf-858c-e3db-af014cf2ccd9@2ndquadrant.com>
<CALhvPTRnqLoS-XAo1MAJEGM=0KuxVua_ATmigELh8EtVhqSjxQ@mail.gmail.com>
On Mon, Nov 05, 2018 at 11:36:46AM +0800, Richard Lee wrote:
> Hi,
>
> Debug symbols can only be enabled during configure? How about when
> Postgresql is running?
If you're running from RPMs (maybe from yum.postgresql.org), you can install
postgresql10-debuginfo (maybe using: "debuginfo-install postgresql10").
Just be sure it installs the debuginfo for exactly the same RPM (rather than
installing a new minor version, for example).
If you compiled it yourself, you can probably point GDB to the un-stripped
binaries. Again, assuming you have binaries from exactly the same source
version, no additional patches, etc.
Justin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pryzby@telsasoft.com, swift1984@gmail.com, tomas.vondra@2ndquadrant.com, pgsql-performance@lists.postgresql.org
Subject: Re: Fwd: Query with high planning time compared to execution time
In-Reply-To: <20181105041009.GY25283@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox