X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C73003A4326 for ; Wed, 24 Nov 2004 17:12:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73882-01 for ; Wed, 24 Nov 2004 17:12:03 +0000 (GMT) Received: from web50001.mail.yahoo.com (web50001.mail.yahoo.com [206.190.38.16]) by svr1.postgresql.org (Postfix) with SMTP id EB1FB3A41B9 for ; Wed, 24 Nov 2004 17:12:00 +0000 (GMT) Received: (qmail 85487 invoked by uid 60001); 24 Nov 2004 17:11:57 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=KmQ4EpfoB/ak5bLDqd58g3otnBRVocaPlw+Yv2Ooqov7/bbGruTG+v+UQg3FHU+66vv/B//9s35rP9cTden8fYfLuf9B0W7lQ0Fq9S3+XF+9r4lwsxph6dLRwZc8gi/vxR5dH3hk51JtmSzf3YLWQyZGuAoXFr4HBwlVd0EgPcc= ; Message-ID: <20041124171156.85485.qmail@web50001.mail.yahoo.com> Received: from [69.65.137.210] by web50001.mail.yahoo.com via HTTP; Wed, 24 Nov 2004 11:11:56 CST Date: Wed, 24 Nov 2004 11:11:56 -0600 (CST) From: Jaime Casanova Subject: Re: [PERFORMANCE] Big number of schemas (3500) into a single database To: performance pgsql In-Reply-To: <4293.1101274362@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/384 X-Sequence-Number: 9338 --- Tom Lane escribió: > "Constantin Teodorescu" 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