Re: [GENERAL] Performance issue with Pointcloud extension - Mailing list pgsql-general

From Eric Lemoine
Subject Re: [GENERAL] Performance issue with Pointcloud extension
Date
Msg-id 3b3a311c-2854-f5a1-011c-388d5ee9574d@oslandia.com
Whole thread Raw
In response to Re: [GENERAL] Performance issue with Pointcloud extension  (Éric <eric.lemoine@oslandia.com>)
Responses Re: [GENERAL] Performance issue with Pointcloud extension  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: [GENERAL] Performance issue with Pointcloud extension  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
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
ratherthan a Pointcloud function. So it may well be a conflict between PostGIS and Pointcloud. Both use fn_extra, and
thatmakes we wonder. This old thread [*] makes me wonder too! I still need to figure out the bug, but I can see some
lightnow! 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.

--
Éric Lemoine
Oslandia
+33 1 86 95 95 55

Attachment

pgsql-general by date:

Previous
From: Harry Ambrose
Date:
Subject: Re: [GENERAL] ERROR: unexpected chunk number 0 (expected 1) for toastvalue 76753264 in pg_toast_10920100
Next
From: armand pirvu
Date:
Subject: Re: [GENERAL] Vacuum and state_change