From: Jorge Godoy <jgodoy@gmail.com>
To: Tony Wasson <ajwasson@gmail.com>
Cc: Jim C. Nasby <jnasby@pervasive.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [SQL] (Ab)Using schemas and inheritance
Date: Tue, 23 May 2006 22:09:45 -0300
Message-ID: <200605232209.48130.jgodoy@gmail.com> (raw)
In-Reply-To: <6d8daee30605231754s58364cd1o79a6520f203a1734@mail.gmail.com>
References: <200605231716.58784.jgodoy@gmail.com>
<20060523232609.GP64371@pervasive.com>
<6d8daee30605231754s58364cd1o79a6520f203a1734@mail.gmail.com>
Em Terça 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.
Thanks. But then, it will degrade a lot when I reach "thousands" of schemas
or it will degrade if I have too many schemas on my search path? It was a
little ambiguous from your answer above.
Be seeing you,
--
Jorge Godoy <jgodoy@gmail.com>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jgodoy@gmail.com, ajwasson@gmail.com, jnasby@pervasive.com, pgsql-general@postgresql.org
Subject: Re: [SQL] (Ab)Using schemas and inheritance
In-Reply-To: <200605232209.48130.jgodoy@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox