--- Tom Lane <tgl@xxxxxxxxxxxxx> escribió: > "Constantin Teodorescu" <teo@xxxxxxx> 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. > if i do a select with fully qualified table names it will search in the search_path or it will go directly to the schema? Just for know. regards, Jaime Casanova _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. VisÃtanos en http://noticias.espanol.yahoo.com