[postgis-users] How to store many tables

[Peter.Tolkewitz at gmx.de]

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