[postgis-users] Geocoder (from extras)

Stephen Frost sfrost at snowman.net
Sun May 8 07:32:57 PDT 2011


* Paragon Corporation (lr at 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 198 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20110508/f25d09ac/attachment.pgp>


More information about the postgis-users mailing list