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 0611113a-4288-fc32-1f8a-5cabe49bff35@oslandia.com
Whole thread Raw
In response to Re: [GENERAL] Performance issue with Pointcloud extension  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> Another idea, if you haven't tried it already, is to run these test cases
> in a server built with --enable-debug and --enable-cassert.  The memory
> clobber stuff that's enabled by the latter is very good at turning coding
> errors into reproducible, debuggable crashes ;-)
>
>             regards, tom lane


We found the cause of the issue! Both the PostGIS and the Pointcloud
extensions define the hexbytes_from_bytes function, and the PostGIS
version is faster. The fix involves prefixing the function name in
Pointcloud, and using a similar implementation as PostGIS [*].

Thanks a lot for helping me fix that issue.

[*] <https://github.com/pgpointcloud/pointcloud/pull/185>


--
Éric Lemoine
Oslandia



Attachment

pgsql-general by date:

Previous
From: "Potukanuma, Vishnu"
Date:
Subject: [GENERAL] FULL_PAGE_WRITES
Next
From: Jov
Date:
Subject: Re: [GENERAL] FULL_PAGE_WRITES