Hi Regina,<div><br></div><div>Thanks for the lead on this.</div><div><br></div><div>It opens up the light and the room for discussion. Well, as far as I know, Oracle Georaster is not good for serving purpose and on top of it, that takes awful amount of time to load the data into Oracle. I assume that its not the case with PG Raster. </div>
<div><br></div><div>The other issue is, even if one dont want to do store the multiband (say 8 band) imagery into the PG Raster for the Speed issue, can we target to link up the Cache into this? If GWC or Tile Cache jpg/png tiles can be kept here and then publish... it will be nice. Again, the issue will be speed ... or some may argue the fact the it defeats the purpose of Cache which is suppose to be non "ram" required serving.</div>
<div><br></div><div>my only wish, that one day we should be able to easily load the images into PG Raster and publish into a web application and get a performance/speed as good as any image servers. </div><div><br></div><div>
btw, it was a news to me that GeoServer dont support PG Raster yet... I hope they are working on it now...</div><div><br></div><div><br></div><div>Thank you;</div><div>Sunny</div><div><br></div><div><br><br><div class="gmail_quote">
On Sun, Jan 30, 2011 at 6:30 AM, Paragon Corporation <span dir="ltr"><<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Sunny,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Good question. I suspect it will be worse at
least at the moment (just as PostGIS was worse when it first came out than
reading from shapefile). How much worse I'm not sure. If you
try and see speed issues, we can tackle them, but it hasn't really been our main
focus.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"> I suspect no one has tested it extensively as far as
dishing out large datasets. The primary focus of PostGIS Raster is for
analysis and then secondary is the rendering. That is not to say it will
work badly or we don't care about rendering speed, just that the GDAL drivers
etc. needed by Mapserver probably still have a few wrinkles which would
make it suboptimal for that kind of work. The more people use it and find
issues, the faster issues will be addressed since we would have data points to
go by.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">As far as GeoServer goes, I recall reading a thread where
Chris Holmes said he would work on a PostGIS Raster support for GeoServer, but
not sure where that is down the pipe, but to my knowledge, GeoServer does
not YET support PostGIS raster.</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial"></font></span> </div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Hope that helps,</font></span></div>
<div dir="ltr" align="left"><span><font color="#0000ff" size="2" face="Arial">Regina</font></span></div><br>
<div dir="ltr" lang="en-us" align="left">
<hr>
<font size="2" face="Tahoma"><b>From:</b>
<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>
[mailto:<a href="mailto:postgis-users-bounces@postgis.refractions.net" target="_blank">postgis-users-bounces@postgis.refractions.net</a>] <b>On Behalf Of </b>Sunny
Teo<br><b>Sent:</b> Saturday, January 29, 2011 3:44 AM<br><b>To:</b>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br><b>Subject:</b> [postgis-users] PostGIS
Raster Performance<br></font><br></div><div><div></div><div class="h5">
<div></div>List,
<div><br></div>
<div>Can anyone comment on the "Performance" of the PostGIS Rater or WKTRaster
?</div>
<div><br></div>
<div>If you were to serve this onto a web application, how effective are they?
Well, I'm talking of very large datasets like 10GB each and 100 of them. How
does it compare with serving the images as files directly.. from a GeoTIFF,
ECW, Sid, etc. (obviously using Geoserver/Mapserver or some specialized image
serving solution)</div>
<div><br></div>
<div>Been searching all over the web for the answers, but no luck.</div>
<div><br></div>
<div>Hope to get some insights from the users.</div>
<div><br></div>
<div><br></div>
<div><br></div>
<div>Thank you;</div>
<div>Sunny. </div></div></div></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="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><br>
<br></blockquote></div><br></div>