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 по дате отправления: