"Constantin Teodorescu" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html