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

From Éric
Subject Re: [GENERAL] Performance issue with Pointcloud extension
Date
Msg-id 1E67E112-57B6-4206-8FE5-0615A1E1977D@oslandia.com
Whole thread Raw
In response to Re: [GENERAL] Performance issue with Pointcloud extension  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] Performance issue with Pointcloud extension
List pgsql-general


>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
thana Pointcloud function. So it may well be a conflict between PostGIS and Pointcloud. Both use fn_extra, and that
makeswe 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>

--
Éric


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: [GENERAL] Db backup
Next
From: marcinha rocha
Date:
Subject: [GENERAL] Function with limit and offset - PostgreSQL 9.3