X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 93D929FA326 for ; Tue, 23 May 2006 22:10:07 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 74257-09 for ; Tue, 23 May 2006 22:10:00 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.195]) by postgresql.org (Postfix) with ESMTP id 3B9119F9D99 for ; Tue, 23 May 2006 22:10:00 -0300 (ADT) Received: by wx-out-0102.google.com with SMTP id s7so513003wxc for ; Tue, 23 May 2006 18:09:59 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:from:to:subject:date:user-agent:cc:references:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:message-id:x-virus-scanned; b=DLvB7qOqKgIZFi2JCFVIxLOFVZQlZOGqsbomzuyuD0VU7Lp388SloKwAhm9r5uB6/i88QlYxoKkysC4yKU8MK0lhjpRA4C3BCQSdxO9LbhmL3cZFTVMoSZBLBrQwEbxglrrDCwzStAsEgp5CR3LufrYj5UGDLbO+JVL8cKW9NWU= Received: by 10.70.48.18 with SMTP id v18mr7061398wxv; Tue, 23 May 2006 18:09:59 -0700 (PDT) Received: from strongwill.g2ctech ( [201.22.53.94]) by mx.gmail.com with ESMTP id h18sm6942888wxd.2006.05.23.18.09.56; Tue, 23 May 2006 18:09:58 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by strongwill.g2ctech (Postfix) with ESMTP id AE96894825; Tue, 23 May 2006 23:09:04 -0300 (BRT) Received: from strongwill.g2ctech ([127.0.0.1]) by localhost (strongwill [127.0.0.1]) (amavisd-new, port 10024) with LMTP id 25871-01; Tue, 23 May 2006 23:09:04 -0300 (BRT) Received: from jupiter.g2ctech (unknown [10.0.0.240]) by strongwill.g2ctech (Postfix) with ESMTP id 86CD294801; Tue, 23 May 2006 23:09:04 -0300 (BRT) Received: from localhost (localhost [IPv6:::1]) by jupiter.g2ctech (Postfix) with ESMTP id 4980DDB760; Tue, 23 May 2006 22:09:50 -0300 (BRT) From: Jorge Godoy To: "Tony Wasson" Subject: Re: [SQL] (Ab)Using schemas and inheritance Date: Tue, 23 May 2006 22:09:45 -0300 User-Agent: KMail/1.9.1 Cc: "Jim C. Nasby" , pgsql-general@postgresql.org References: <200605231716.58784.jgodoy@gmail.com> <20060523232609.GP64371@pervasive.com> <6d8daee30605231754s58364cd1o79a6520f203a1734@mail.gmail.com> In-Reply-To: <6d8daee30605231754s58364cd1o79a6520f203a1734@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200605232209.48130.jgodoy@gmail.com> X-Virus-Scanned: amavisd-new at g2ctech.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/1125 X-Sequence-Number: 95917 Em Ter=E7a 23 Maio 2006 21:54, Tony Wasson escreveu: > > $.02 about lots of schemas. > > I worked with an application that had 500 schemas and that worked very > well. However, as the number of schemas exceeeded 8000 the query speed > started to degrade. Running \d with a single schema in your search > path took a few seconds with that many schemas. Queries that were > running in 100ms were now taking about 600ms. > > In short, postgresql will support lots of schemas. Hi Tony.=20 Thanks. But then, it will degrade a lot when I reach "thousands" of schema= s=20 or it will degrade if I have too many schemas on my search path? It was a= =20 little ambiguous from your answer above. Be seeing you, =2D-=20 Jorge Godoy