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