What are the best practices for performance when using a large PostGIS
table.
I have imported the OSM data for The Netherlands in PostGIS v2.
I have several workspaces in GeoServer that are for small parts of The
Netherlands.
I want to add OSM data for that region to my workspace.
What is best to do:
1. Create a view in PostGIS using a bounding box restriction to return only
the small region I'm interested in and create a GS layer of that.
2. Copy the data I'm interested in from PostGIS to another PostGIS
database/tables.
3. Don't use PostGIS, but use shapefiles. These shapefiles are clipped by
the interested region.
I will be using GWC to tile most zoom levels.
Thanks,
Paul
------------------------------------------------------------------------------
Monitor your physical, virtual and cloud infrastructure from a single
web console. Get in-depth insight into apps, servers, databases, vmware,
SAP, cloud infrastructure, etc. Download 30-day Free Trial.
Pricing starts from $795 for 25 servers or applications!
http://p.sf.net/sfu/zoho_dev2dev_nov
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
