[postgis-users] Loading Tiger2007fe data - Thoughts on using inherited tables

[Paul Ramsey]

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 <sfrost at snowman.net> wrote:
> Stephen,
>
>
>  * Stephen Woodbridge (woodbri at swoodbridge.com) 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
>  postgis-users at postgis.refractions.net
>  http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>