* 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

Attachment: signature.asc
Description: Digital signature

_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to