[postgis-users] Are views slow ing down my wms?

[Francois Hugues]

Hello,

 

It will take sometimes to retrieve the set of data from the view relative to its complexity. Is the request which define the view simple or does it have complex and / or spatial operator ? Does your spatial data have a lot of points ? Did you make indexes on the columns used by your views ?

 

Hugues.

 

 

________________________________

De : postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] De la part de Robert Buckley
Envoyé : jeudi 12 juillet 2012 07:30
À : Post GIS Users Discussion
Objet : [postgis-users] Are views slow ing down my wms?

 

Hi,

 

I have created a database structure which has 3 main postgis tables (1 for lines,polygones, and points) which each contain between 5-10,000 features. These tables then feed views which split the geometries into understandable groups which are then served through geoserver in Tomcat6, linux-Ubuntu 10.04.

 

I have noticed that the performance of the wms is getting considerably worse. Is this to do with the views or simply the amount of data being served?

 

Should I in hindsight have split the table into separate tables instead of creating views?

 

thanks for any help,

 

Robert

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120712/e104f600/attachment.html>