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, <j...@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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to