Re: Fwd: Query with high planning time compared to execution time

Поиск
Список
Период
Сортировка
От Justin Pryzby
Тема Re: Fwd: Query with high planning time compared to execution time
Дата
Msg-id 20181105041009.GY25283@telsasoft.com
обсуждение исходный текст
Ответ на Re: Fwd: Query with high planning time compared to execution time  (Richard Lee <swift1984@gmail.com>)
Ответы Re: Fwd: Query with high planning time compared to execution time  (Richard Lee <swift1984@gmail.com>)
Список pgsql-performance
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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Richard Lee
Дата:
Сообщение: Re: Fwd: Query with high planning time compared to execution time
Следующее
От: Richard Lee
Дата:
Сообщение: Re: Fwd: Query with high planning time compared to execution time