Re: [GENERAL] Performance issue with Pointcloud extension

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Performance issue with Pointcloud extension
Дата
Msg-id 2824.1497048368@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] Performance issue with Pointcloud extension  (Jeff Janes <jeff.janes@gmail.com>)
Ответы Re: [GENERAL] Performance issue with Pointcloud extension
Список pgsql-general
Jeff Janes <jeff.janes@gmail.com> writes:
> On Fri, Jun 9, 2017 at 9:13 AM, Eric Lemoine <eric.lemoine@oslandia.com>
> wrote:
>> I now think that the performance bug is not related to the fn_extra
>> thing. I had hope but not anymore :) I don't see where the Pointcloud
>> and PostGIS extensions could conflict.

> Can you run 'perf top' on the slow query?  That might pretty quickly tell
> you which function is taking up your time.

Another idea, if you haven't tried it already, is to run these test cases
in a server built with --enable-debug and --enable-cassert.  The memory
clobber stuff that's enabled by the latter is very good at turning coding
errors into reproducible, debuggable crashes ;-)

            regards, tom lane


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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Vacuum and state_change
Следующее
От: armand pirvu
Дата:
Сообщение: Re: [GENERAL] Vacuum and state_change