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

[Stephen Frost]

* Paul Ramsey (pramsey at cleverelephant.ca) 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 <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
> >
> >
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080404/91b781c0/attachment.pgp>