Re: [postgis-users] ST_ConcaveHull performance issue

[Komяpa]

Hi,

There were changes ST_ConcaveHull that fixed robustness of it in 2.2 -> 2.5
chain.
To point where the penalty comes from, try to run a query and on a side
console server-side run `sudo perf top`. Function names will get you a
rough idea where the execution process lives now.

To further debug, go to blame view in github and try updating
st_concavehull (it's in SQL) change by change. Most recent adds an union
here, try commenting it out and hot reloading on your db.
https://github.com/postgis/postgis/blame/svn-trunk/postgis/postgis.sql.in#L6155

Can you share the data and ticket this on http://trac.osgeo.org/postgis/?

What is the data structurally? Are these 6000 objects points, or polygons?


On Fri, Aug 2, 2019 at 3:43 AM Trevor Wiens  wrote:

> I am having difficulty determining why I'm seeing significant differences
> in performance between two database configurations with the same data.
>
> One one machine (centos) I have the following software:
> geos 3.5.0
> sfcgal 1.3.1
> cgal 4.7.1
> postgis 2.2
> postgresql 9.4
>
> On a second machine (debian 10) I have the following:
> geos 3.7.1
> sfcgal 1.3.6
> cgal 4.13
> postgis 2.5.2
> postgresql 9.6
>
> In terms of hardware there is no significant difference, if anything the
> second machine is more capable, but that is not reflected in my performance
> results.
>
> On the first machine when I run a ST_ConcaveHull with about 6000 features,
> I get result a second or two. On the second machine, it won't finish within
> 30 minutes. Both are using geos as the postgis.backend. I don't understand
> why the one is so much faster than the other with the identical data and
> query.
>
> Any suggestions as to what to what the cause may be or how I might
> diagnose the cause?
>
> Any clues would be greatly appreciated.
>
> TSW
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS setup on Postgres-XL

[Pradeep Kanth G]

Thanks David for your reply. Sure we will try with citusDB also.

We already HA setup with Postgres-Xl 9.5. Kindly suggest us how to implement 
PostGIS on that server.

 

Regards

Pradeep Kanth

 

From: postgis-users  On Behalf Of David 
Haynes
Sent: Friday, August 2, 2019 6:56 AM
To: PostGIS Users Discussion 
Subject: Re: [postgis-users] PostGIS setup on Postgres-XL

 

It might be easier to use citusDB.

 

On Wed, Jul 31, 2019, 5:09 AM Pradeep Kanth G mailto:pgund...@avineonindia.com> > wrote:

Dear All, 

Recently, I have enable the Postgres-XL cluster setup but unable to 
configure the postGIS. 
Kindly help us how to configure on the cluster. 

 

Regards

Pradeep Kanth

 

Disclaimer | The information contained in this electronic message (including 
any attachments) is intended for the exclusive use of the addressee(s) and may 
contain confidential or privileged information.If you have received this in 
error, please notify the sender immediately and delete the material from your 
machine. Any  action including review, retransmission, dissemination of this 
email or the attachments present along with the email by persons or entities 
other than the intended recipient is prohibited.





___
postgis-users mailing list
postgis-users@lists.osgeo.org  
https://lists.osgeo.org/mailman/listinfo/postgis-users



Disclaimer | The information contained in this electronic message (including 
any attachments) is intended for the exclusive use of the addressee(s) and may 
contain confidential or privileged information.If you have received this in 
error, please notify the sender immediately and delete the material from your 
machine. Any  action including review, retransmission, dissemination of this 
email or the attachments present along with the email by persons or entities 
other than the intended recipient is prohibited.



___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS setup on Postgres-XL

[David Haynes]

It might be easier to use citusDB.

On Wed, Jul 31, 2019, 5:09 AM Pradeep Kanth G 
wrote:

> Dear All,
>
> Recently, I have enable the Postgres-XL cluster setup but unable to
> configure the postGIS.
> Kindly help us how to configure on the cluster.
>
>
>
> Regards
>
> Pradeep Kanth
>
>
> *Disclaimer *| The information contained in this electronic message
> (including any attachments) is intended for the exclusive use of the
> addressee(s) and may contain confidential or privileged information.If you
> have received this in error, please notify the sender immediately and
> delete the material from your machine. Any  action including review,
> retransmission, dissemination of this email or the attachments present
> along with the email by persons or entities other than the intended
> recipient is prohibited.
>
>
>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

[postgis-users] ST_ConcaveHull performance issue

[Trevor Wiens]

I am having difficulty determining why I'm seeing significant differences
in performance between two database configurations with the same data.

One one machine (centos) I have the following software:
geos 3.5.0
sfcgal 1.3.1
cgal 4.7.1
postgis 2.2
postgresql 9.4

On a second machine (debian 10) I have the following:
geos 3.7.1
sfcgal 1.3.6
cgal 4.13
postgis 2.5.2
postgresql 9.6

In terms of hardware there is no significant difference, if anything the
second machine is more capable, but that is not reflected in my performance
results.

On the first machine when I run a ST_ConcaveHull with about 6000 features,
I get result a second or two. On the second machine, it won't finish within
30 minutes. Both are using geos as the postgis.backend. I don't understand
why the one is so much faster than the other with the identical data and
query.

Any suggestions as to what to what the cause may be or how I might diagnose
the cause?

Any clues would be greatly appreciated.

TSW
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users

Re: [postgis-users] PostGIS setup on Postgres-XL

[Komяpa]

Hi,

Please describe the problem you're facing more precisely.

On Thu, Aug 1, 2019 at 7:45 AM Pradeep Kanth G 
wrote:

> Anyone did it?
>
>
>
> Regards
>
> Pradeep Kanth
>
>
>
> *From:* postgis-users  *On Behalf
> Of *Pradeep Kanth G
> *Sent:* Wednesday, July 31, 2019 3:41 PM
> *To:* 'PostGIS Users Discussion' 
> *Subject:* [postgis-users] PostGIS setup on Postgres-XL
>
>
>
> Dear All,
>
> Recently, I have enable the Postgres-XL cluster setup but unable to
> configure the postGIS.
> Kindly help us how to configure on the cluster.
>
>
>
> Regards
>
> Pradeep Kanth
>
>
>
> *Disclaimer *| The information contained in this electronic message
> (including any attachments) is intended for the exclusive use of the
> addressee(s) and may contain confidential or privileged information.If you
> have received this in error, please notify the sender immediately and
> delete the material from your machine. Any  action including review,
> retransmission, dissemination of this email or the attachments present
> along with the email by persons or entities other than the intended
> recipient is prohibited.
>
>
>
>
>
> *Disclaimer *| The information contained in this electronic message
> (including any attachments) is intended for the exclusive use of the
> addressee(s) and may contain confidential or privileged information.If you
> have received this in error, please notify the sender immediately and
> delete the material from your machine. Any  action including review,
> retransmission, dissemination of this email or the attachments present
> along with the email by persons or entities other than the intended
> recipient is prohibited.
>
>
>
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users



-- 
Darafei Praliaskouski
Support me: http://patreon.com/komzpa
___
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users