Re: [GRASS-user] Grass and Postgre limitation (if any)
On 05/04/09 19:10, Jarek Jasiewicz wrote: Hi I have short question. I'm prepraring to create huge dataset, where data for different regions will be stored in different mapset but with the same structure of data (names of files and so on). The number of planned mapset is about 200-230, with about 10 postgreeSQL tables in every mapset. IT gives about 2000-2300 tables in one database. Tables will be use datatypes unique for postgreeSQL contribs so different databes solution cannot be used. The question is is some of the numbers above are not close to these program limitation (i.e number of mapset) or number of tables I'm not sure for GRASS, but I think that in both cases the limits will be mostly defined by your OS (i.e. max number of sub-directories or max number of files), and not by the program. You can try it out in a test location, loopping through g.mapset -c commands to see whether you reach a limit at one point. Moritz ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
Re: [GRASS-user] Grass and Postgre limitation (if any)
I still don't know about the limit but I reached the number of 1000 for mapsets and 1 for tables which is enaugh for me Thanks for useful hint Jarek Moritz Lennert pisze: On 05/04/09 19:10, Jarek Jasiewicz wrote: Hi I have short question. I'm prepraring to create huge dataset, where data for different regions will be stored in different mapset but with the same structure of data (names of files and so on). The number of planned mapset is about 200-230, with about 10 postgreeSQL tables in every mapset. IT gives about 2000-2300 tables in one database. Tables will be use datatypes unique for postgreeSQL contribs so different databes solution cannot be used. The question is is some of the numbers above are not close to these program limitation (i.e number of mapset) or number of tables I'm not sure for GRASS, but I think that in both cases the limits will be mostly defined by your OS (i.e. max number of sub-directories or max number of files), and not by the program. You can try it out in a test location, loopping through g.mapset -c commands to see whether you reach a limit at one point. Moritz ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
[GRASS-user] Grass and Postgre limitation (if any)
Hi I have short question. I'm prepraring to create huge dataset, where data for different regions will be stored in different mapset but with the same structure of data (names of files and so on). The number of planned mapset is about 200-230, with about 10 postgreeSQL tables in every mapset. IT gives about 2000-2300 tables in one database. Tables will be use datatypes unique for postgreeSQL contribs so different databes solution cannot be used. The question is is some of the numbers above are not close to these program limitation (i.e number of mapset) or number of tables Mayebe in the feature data will be merged into one dataset but for now I have no idea how. Thanks for answer Jarek ___ grass-user mailing list grass-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-user
