* Paragon Corporation (l...@pcorp.us) wrote: > I'm not sure how much preplanning will help. Because plans are cached in > PostgreSQL for these dynamic like queries and I think they are actually > cached across sessions using shared memory. So upping shared memory helps > quite a bit.
We're using execute though, so the main query isn't cache'd at all.. Stephen
signature.asc
Description: Digital signature
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users