<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16455"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>Shaun,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>That's the best time to start finding performance issues,
before we release. So keep it coming.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>As far as reporting these, please post a ticket to
trac</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial><A
href="http://trac.osgeo.org/postgis/wiki">http://trac.osgeo.org/postgis/wiki</A>
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>with Milestonre 2.1.0 and the</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>SELECT version();</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>SELECT postgis_full_version();</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>of your install.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>More importantly a sample data output e.g. geometry wkt or a
table with single record that is really slow.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>If it's a performance issue, make sure to note the timing you
are getting.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>realityexists is really good at posting bug reports, so his is
probably a good model to follow: Here is an example of
his</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial><A
href="http://trac.osgeo.org/postgis/ticket/2066">http://trac.osgeo.org/postgis/ticket/2066</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>Thanks,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=251575613-08122012></SPAN> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@lists.osgeo.org
[mailto:postgis-users-bounces@lists.osgeo.org] <B>On Behalf Of </B>Shaun
Walbridge<BR><B>Sent:</B> Friday, December 07, 2012 10:04 PM<BR><B>To:</B>
postgis-users@lists.osgeo.org<BR><B>Subject:</B> [postgis-users]
ST_Segmentize(geography) perfomance?<BR></FONT><BR></DIV>
<DIV></DIV>Hello,
<DIV><BR></DIV>
<DIV>I'd like to use the bleeding-edge feature of ST_Segmentize on a collection
of about 20,000 multilinestring geometries, each containing 1000-50000 vertices.
For most of my geometries, things went without a hitch, but a couple of
subtables seem to just 'hang' when trying to segmentize. I've mucked around with
my shared_buffers to make sure that the geometries can fit into memory, but it
doesn't seem to have helped. My query looks like this:</DIV>
<DIV><BR></DIV>
<DIV><FONT face="courier new, monospace">CREATE TABLE arcs_input AS SELECT id,
name, count, ST_Segmentize(geog, 10000) as loc FROM lines_input;</FONT></DIV>
<DIV><BR></DIV>
<DIV>I know this is still only in SVN, but what's the best way for me to help
debug this issue?</DIV>
<DIV><BR></DIV>
<DIV>cheers,</DIV>
<DIV>Shaun</DIV></BODY></HTML>