<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=blue>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Wow! Where are the ST_Simplify and other
functions docuemented- in PostGIS docs or MapServer docs?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b><span
style='font-weight:bold'>On Behalf Of </span></b>pcreso@pcreso.com<br>
<b><span style='font-weight:bold'>Sent:</span></b> Tuesday, February 14, 2012
2:44 PM<br>
<b><span style='font-weight:bold'>To:</span></b> PostGIS Users Discussion<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [postgis-users]
advice for quicker display?</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0>
<tr>
<td valign=top style='padding:0in 0in 0in 0in'>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>Also,<br>
<br>
In Postgis you can use the ST_Simplfy() function in mapserver zoom (scale
dependent) layers. So you have one dataset, and as you zoom out you display
features represented by progressively fewer vertices. You don't need every
headland of a global coastline dataset plotted until you until you zoom
in. This can give vastly better performance than a shapefile when zoomed out.<br>
<br>
You can use pre-prepared geometries, so each record has more than one
geometry column, or you can do the point reduction on the fly (in the SQL
command in the mapfile DATA statement), whichever meets your needs.<br>
<br>
The default Postgres configuration is for pretty basic hardware. You might
find & run pgtune, or look at the postgres admin docs to configure it to
more effectively use the available memory, and see how to use tablespaces to
manage data & indexes across filesystems to increase overall disk
throughput. <br>
<br>
So it takes some work, but overall, Postgis provides spatial data management
tools with substantial performance optimisation capabilities. But you need to
use them.<br>
<br>
For plotting an entire unsimplified dataset, the overhead of a database will
always be somewhat slower than a file streaming from disk. Note that on good
hardware with an well optimised database even this difference can be
minimised.<br>
<br>
Cheers,<br>
<br>
Brent Wood<br>
<br>
--- On <b><span style='font-weight:bold'>Wed, 2/15/12, Stephen Woodbridge <i><span
style='font-style:italic'><woodbri@swoodbridge.com></span></i></span></b>
wrote:<o:p></o:p></span></font></p>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><br>
From: Stephen Woodbridge <woodbri@swoodbridge.com><br>
Subject: Re: [postgis-users] advice for quicker display?<br>
To: postgis-users@postgis.refractions.net<br>
Date: Wednesday, February 15, 2012, 8:14 AM<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>On 2/14/2012 1:57 PM, Bistrais, Bob wrote:<br>
> As some of you already know, I’m a newbie to PostGIS and have just<br>
> barely got a test PostGIS database up and running. So, my latest<br>
> question is in regards to draw times. I created a statewide parcel layer<br>
> from a shapefile. At statewide scale, when the application loads, the<br>
> parcel data draws far slower than the original shapefile did. How can I<br>
> tune this so that draw times are better?<br>
<br>
If you are drawing all the data, it will always be slower than shapefiles.
The trick is to not draw more than is reasonable at a given scale. So the
answer is don't try to draw all the parcels for the whole state. As you zoom
in and need to only draw a subset of the parcels, you will start to get speed
advantages by using the spatial (GIST) indexes in postgis.<br>
<br>
create index mytable_the_geom_gidx on mytable using gist (the_geom);<br>
<br>
-Steve W<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="/mc/compose?to=postgis-users@postgis.refractions.net"
ymailto="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users"
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><o:p></o:p></span></font></p>
</div>
</td>
</tr>
</table>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>