[postgis-users] Large Databases

Jim C. Nasby jnasby at pervasive.com
Fri Jun 9 12:45:03 PDT 2006


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



More information about the postgis-users mailing list