[postgis-users] Large point table

[Stephen Crawford]

All,

I have a table of about 30 million point observations.  The geometries are
stored in lon/lat., with a gist index on the column.  For display and
analysis I want to use an albers projection....mostly I'm aggregating the
points to a grid.  Currently I just do the transform(geom) in my queries.
Would it be better for me to perhaps create a view with the tranformation
instead of in my query....or should I instead create another geometry column
in the original table, with the tranformation and do another gist index on
the new column?  What's the best approach?

Thanks,
Steve


Stephen Crawford
Center for Environmental Informatics
The Pennsylvania State University