From: | Eric Lemoine <eric(dot)lemoine(at)oslandia(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Performance issue with Pointcloud extension |
Date: | 2017-06-09 16:13:23 |
Message-ID: | 3b3a311c-2854-f5a1-011c-388d5ee9574d@oslandia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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 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(dot)ca#984D0F47C5FF4D0DB0D71A4F6EF670ED(at)cleverelephant(dot)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 | Content-Type | Size |
---|---|---|
eric_lemoine.vcf | text/x-vcard | 209 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | armand pirvu | 2017-06-09 16:13:51 | Re: Vacuum and state_change |
Previous Message | Harry Ambrose | 2017-06-09 16:02:50 | Re: ERROR: unexpected chunk number 0 (expected 1) for toast value 76753264 in pg_toast_10920100 |