Re: [GENERAL] Performance issue with Pointcloud extension

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [GENERAL] Performance issue with Pointcloud extension
Дата
Msg-id CAMkU=1x7XX=uwfD0Ruj3kBnSa98iybW0dFtsE5Ho-KMiGuD1Mg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Performance issue with Pointcloud extension  (Eric Lemoine <eric.lemoine@oslandia.com>)
Ответы Re: [GENERAL] Performance issue with Pointcloud extension
Список pgsql-general
On Fri, Jun 9, 2017 at 9:13 AM, Eric Lemoine <eric.lemoine@oslandia.com> wrote:
On 06/08/2017 10:41 PM, Éric wrote:
>
>
>
>> Have you experimented with other queries that don't involve PostGIS?
>> I'm wondering if your hook-installation code fails to work properly
>> unless PostGIS was loaded first.  This would be easier to credit if
>> there are hooks both extensions try to get into.
>
>
> I think you're right on Tom. It looks like I cannot reproduce the issue if I start by calling a PostGIS function rather than a Pointcloud function. So it may well be a conflict between PostGIS and Pointcloud. Both use fn_extra, and that makes we wonder. This old thread [*] makes me wonder too! I still need to figure out the bug, but I can see some light now! thanks
>
> [*] <https://www.postgresql.org/message-id/flat/984D0F47C5FF4D0DB0D71A4F6EF670ED%40cleverelephant.ca#984D0F47C5FF4D0DB0D71A4F6EF670ED@cleverelephant.ca>


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.

Cheers,

Jeff

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Performance issue with Pointcloud extension
Следующее
От: Joe Conway
Дата:
Сообщение: Re: [GENERAL] Limiting DB access by role after initial connection?