Re: [mapserver-users] long-running postgres queries initiated by mapserver

ecember 21, 2010 10:43:46 AM Subject: RE: [mapserver-users] long-running postgres queries initiated by mapserver Carlos, Thank you for your response, and indeed the tables do have indices. The spatial search is just fine and comes back very quickly, however the text-based searches

RE: [mapserver-users] long-running postgres queries initiated by mapserver

ver-users] long-running postgres queries initiated by mapserver Matt, I suggest to enhance the PostgreSQL performance at first. Each table with geometry must have a GiST spatial index. When you upload a shape file to PostgreSQL, the shp2pgsql creates this index specifying the -I parameter. Ha

Re: [mapserver-users] long-running postgres queries initiated by mapserver

Matt, I suggest to enhance the PostgreSQL performance at first. Each table with geometry must have a GiST spatial index. When you upload a shape file to PostgreSQL, the shp2pgsql creates this index specifying the -I parameter. Have you uploaded your data in this way ? If the geometry have