Schemas don't really control where tables are stored. Schemas are more of an organization structure which for that many customers you would probably want to do anyway just to keep your sanity.
The downside of using schemas is that you have to prefix your tables with the schema names when you use them in selects. Now for storing your tables in different locations to optimize speed - you probably want to fiddle around with RAID configurations and PostgreSQL table spaces (table spaces were released around PostgreSQL 8.0-8.1). You can control what table spaces a table sits in on a case by case basis and a table space maps to a location on disk. http://www.postgresql.org/docs/8.1/static/manage-ag-tablespaces.html Hope that helps, Regina -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, September 25, 2007 9:23 AM To: [email protected] Subject: [postgis-users] How to store many tables Hi, what is the "most performant" way to store about 10000 customer related tables (number increasing) within postgresql? I want to use one database to store it, but I'm afraid of the fact that file access times will decrease while more and more tables get created? Is it possible/suggested to split up the bunch of tables into different schemas? If yes, am I able to join tables stored within different schemas? Thank you, Peter -- GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
