Look at "constraint exclusion" as a strategy... http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html
It actually *does* use inheritance, but it does fancy query re-writes too. P. On Fri, Apr 4, 2008 at 11:10 AM, Stephen Frost <[EMAIL PROTECTED]> wrote: > Stephen, > > > * Stephen Woodbridge ([EMAIL PROTECTED]) wrote: > > Have look into using inherited tables? This would allow you to have a > > nation view or a state view of the county data. View being used in the > > literal not postgres in this case. > > Honestly, I havn't. I'm really not all that keen on inheiritance in PG > anyway. What I'm probably going to do instead though, so you know, is > combine all of the county-level data into state-level tables, and then > create a view across the state tables to generate a national table. > This partitioning should make things go pretty quickly, imv. I'll > certainly let folks know if I'm happy with it or not. > > Thanks, > > Stephen > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.6 (GNU/Linux) > > iD8DBQFH9m8DrzgMPqB3kigRAhj1AJ9upuYPkTNrzLQWv74QW1hewjtxJQCfXCZy > feifOYH9dPLDphnwVOd788M= > =izsS > -----END PGP SIGNATURE----- > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
