hello!!
I have a little question about performance with postgis and geoserver. It’s better to have a big table of or a lot of small tables?
Thanks
Jim
I am not sure I quite understand the question. In GeoServer a layer can be backed by only a single table, unless that table is a view composed of a join or union of multiple tables.
The primary thing to keep in mind when thinking of performance with postgis is indexing, make sure your tables are properly indexed spatially, and properly indexed in terms of attributes which are being filtered on via queries, or via SLD.
You could potentially break a big dataset up into multiple tables, perhaps based on region, but you would eventually have to bring them together anyways, or publish them as different layers.
-Justin
Jimmy Aumard wrote:
hello!!
I have a little question about performance with postgis and geoserver. It's better to have a big table of or a lot of small tables?
Thanks
Jim
------------------------------------------------------------------------
------------------------------------------------------------------------------
------------------------------------------------------------------------
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.