[postgis-users] design problem

Stephen V. Mather svm at clevelandmetroparks.com
Fri Mar 1 14:09:10 PST 2013


Ah, partitioning seems like it should work, but if you're doing it for the sake of query optimization, you would have to write some funky (and technically non-spatial or a mix of spatial and non-spatial) queries to ensure the partitioning accomplishes anything.

See the comments from Regina on Paul Ramsey's post here:

http://blog.cleverelephant.ca/2011/02/spatial-partitioning-in-postgis.html

AFAIK, no work has gone into enabling the range functions used in partitioning to leverage spatial partitioning.  It would be nice for large datasets though... .

BTW, like others have indicated, it would help to have for excising and recreating sections of the dataset, in the case of datasets that change a lot and are really big... .

Hope this helps,
Best,
Steve

  Stephen V. Mather
GIS Manager
(216) 635-3243 (Work)
clevelandmetroparks.com


________________________________________
From: postgis-users-bounces at lists.osgeo.org [postgis-users-bounces at lists.osgeo.org] on behalf of Denise Janson [denise.j.ferreira at gmail.com]
Sent: Friday, March 01, 2013 4:11 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] design problem

Hi,

I have an application that is going to receive lots of georeferenced files
every day. Each file has information of several points. Probably in few
years my application will have a Tera of points information stored.

I think I can do this design  in two ways:

1. Two tables, one of “uploaded_files”, and another of “points” (one
uploadedFile to N points). And I'll have to partition the points table,
maybe by month …
2. Or I can create one table per file, having thousands of tables in few
years.

Which case is better for my application?  Is there any better way to do
this?



--
View this message in context: http://postgis.17.n6.nabble.com/design-problem-tp5002778.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
_______________________________________________
postgis-users mailing list
postgis-users at lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users



More information about the postgis-users mailing list