Re: [GENERAL] Performance issue with Pointcloud extension

Поиск
Список
Период
Сортировка
От Éric
Тема Re: [GENERAL] Performance issue with Pointcloud extension
Дата
Msg-id 1E67E112-57B6-4206-8FE5-0615A1E1977D@oslandia.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Performance issue with Pointcloud extension  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [GENERAL] Performance issue with Pointcloud extension
Список 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 по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: [GENERAL] Db backup
Следующее
От: marcinha rocha
Дата:
Сообщение: [GENERAL] Function with limit and offset - PostgreSQL 9.3