[postgis-users] How many tables for loading tiger data

[Mike Toews]

Definitely one table. Add a column or more to partition your data by
Country/State/whatever in the same table, and if you are worried about
performance for searching on these columns, add an index on these columns.

-Mike

On 8 April 2010 21:15, <joe at dabader.com> wrote:

> I am going to load tiger data and do reverse geocodes and find nearby
> street queries.
>
> Is it a good idea to load all the road/line data for each county into one
> table or multiple tables by county or state, or some other pre processing on
> the data?
>
> TIA
> -Joe
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100408/5f51ebcf/attachment.html>