[postgis-users] How to store many tables

[Obe, Regina]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Peter.Tolkewitz at gmx.de
Sent: Tuesday, September 25, 2007 9:23 AM
To: postgis-users at postgis.refractions.net
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
postgis-users at postgis.refractions.net
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.