Hi Sebastian, What kind of query are you planning on the raster? You know you can also use WKT Raster to simply "register" filesystem rasters, creating a king of geospatial catalog, without actually storing them in the database...
How many 16GB raster do you have? Are your raster all representing the same theme? Are they overlapping (or they form a regular grid)? We don't know of that many users cases up to now, but WKT Raster prooved to be very stable working on 1 GB raster coverage (see the tutorial). Pierre From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Sebastian E. Ovide Sent: 19 juillet 2010 11:34 To: PostGIS Users Discussion Subject: Re: [postgis-users] may have postgis store limits for a big project? Hi All, I am interesting too... I am considering PostGIS+WKTRaster instead of Oracle GeoRaster... but for that can happen, Postgresql must be able of managing some simple tables of 30+M (Millions) rows plus a lot of Rasters of 16GB each... (16GB not compress data... so are huge images !). Each query (simple look up) must response in a fraction of second.... any successful case ? Thanks ! On Fri, Jul 16, 2010 at 1:13 AM, salas <fsa...@geocuba.cu<mailto:fsa...@geocuba.cu>> wrote: Hello to all: I am working in a project where they are managed more than 20 geoespatials thematics. Each thematic one has a considerable volume of since information it is of the whole country (I am speaking of a lot more than a million of records). In the project we need to make (mostly) intersection consultations keeping in mind literal attributes. I need to know the experience of somebody in a project of this span and if PostGIS would present some limitation therewith. regards yuriesky _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net<mailto:postgis-users@postgis.refractions.net> http://postgis.refractions.net/mailman/listinfo/postgis-users -- Sebastian E. Ovide
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users