Thread: Big number of schemas (3500) into a single database

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Hello to everybody again,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">thought you didn’t hear any news from me for a very long time, the news are good </span></font><font
face="Wingdings"size="2"><span style="font-size:10.0pt;font-family:Wingdings">J</span></font><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;font-family:Arial"></span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">I’m still here and promoting PostgreSQL.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I am involved in the developing of a big romanian project for the vets that will put Linux &
PostgreSQLon 3500 computers in the whole country, linked together with dial-up connections that will keep track of the
animalmovements.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">The central database (also PostgreSLQ) will hold billions of records with animal events (births,
movements,slaughter and so on) and my question is:</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">If I will choose to keep a mirror of every workstation database in a separate schema in the central
databasethat mean that I will have 3500 different schemas.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial">Is there any limit or any barrier that could stop this kind of approach or make things go
slower?</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Constantin Teodorescu</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">Ancient PgAccess developer</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">P.S. Please Cc: me at <a href="mailto:teo@flex.ro">teo@flex.ro</a></span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font></div>

"Constantin Teodorescu" <teo@flex.ro> writes:
> If I will choose to keep a mirror of every workstation database in a
> separate schema in the central database that mean that I will have 3500
> different schemas.

> Is there any limit or any barrier that could stop this kind of approach or
> make things go slower?

Would you need to put them all into "search_path" at once?

I'm not sure what the scaling issues might be for long search_paths, but
I wouldn't be surprised if it's bad.  But as long as you don't do that,
I don't believe there will be any problems.
        regards, tom lane