Hi,
Performance wise it does not matter whether you have one or multiple
databases. You can also split a single database into multiple
tablespaces on multiple disks.
I would opt for one big database for everything. Table joins across
multiple databases is complicated and does not work out of the box in
PostgreSQL. The only drawback with one big database is that the dump
files (backup or migration) get fairly large.
Andreas
On Wed, 9 May 2012 13:48:38 +0700, Koos Hagg wrote:
Hi all,
Only recently have I started using databases more often. I like
Spatialite for its single file solution, I can easily share data with
others... PostGIS is great too, happy that they have 64 Windows now.
Performance wise- in QGIS:
Is it better to have one big Database (PostGIS or Spatialite or
whatever) with all of your layers/tables in there, or to have several
smaller databases, each containing their own family of data
For example,
I could have one database for OSM data from Geofabrik, one database
with Natural Earth data, and one database with my own data., etc
-or-
I could stuff all of those into one big database.
Which approach is the better practice? Will accessing several
databases in QGIS at the same time vs one big db be any different in
performance?
If I'm working with PostGIS, would it make sense to separate the
different data groups (OSM, Natural Earth, etc) into different
schemas? Would there be any benefit to that?
Thanks!
Koos
--
--
Andreas Neumann
Böschacherstrasse 10A
8624 Grüt (Gossau ZH)
Switzerland
_______________________________________________
Qgis-user mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/qgis-user
