[postgis-users] Large Databases

[Jim C. Nasby]

On Fri, Jun 09, 2006 at 02:29:52PM -0500, mark thomas wrote:
> Consider using table partitioning by state, zip code, county, or
> something similar to help speed up queries.  Also, when loading your
> data, I found it helpful to make sure I vacuumed/analyzed the DB after
> every state load; otherwise, it took forever trying to gather statistics
> on the entire U.S detailed streets dataset.  

On what version? Recent versions of PostgreSQL will only read a maximum
of 30,000 pages per relation on an ANALYZE.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby at pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461