* Paul Ramsey ([EMAIL PROTECTED]) wrote: > Look at "constraint exclusion" as a strategy...
Yes, certainly this approach will be taking advantage of constraint exclusion. > http://www.postgresql.org/docs/8.1/interactive/ddl-partitioning.html > > It actually *does* use inheritance, but it does fancy query re-writes too. It can also be done with a simple view, and since we're not going to be updating the tiger tables, or adding new rows, or adding new tables, it's alost simpler/easier/cleaner to just create the necessary views once (with the correct where clauses with constant values) than set up inheiritance and whatnot. Thanks, Stephen > 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
signature.asc
Description: Digital signature
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
