From: Tony Wasson <ajwasson@gmail.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Jorge Godoy <jgodoy@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: [SQL] (Ab)Using schemas and inheritance
Date: Tue, 23 May 2006 17:54:09 -0700
Message-ID: <6d8daee30605231754s58364cd1o79a6520f203a1734@mail.gmail.com> (raw)
In-Reply-To: <20060523232609.GP64371@pervasive.com>
References: <200605231716.58784.jgodoy@gmail.com>
<20060523232609.GP64371@pervasive.com>
On 5/23/06, Jim C. Nasby <jnasby@pervasive.com> wrote:
> > Is this a good idea? Would this be too bad, performance-wise, if I had
> > thousands of schemas to use like that? Any advice on better approaches? Any
> > expected problems?
>
> One issue is that you'll probably be breaking new ground here a bit; I
> suspect there's very few people that are using more than a handful of
> schemas. Shouldn't pose any issues, but you never know; although any
> issues you do run into should only be performance problems.
$.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.
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: ajwasson@gmail.com, jnasby@pervasive.com, jgodoy@gmail.com, pgsql-general@postgresql.org
Subject: Re: [SQL] (Ab)Using schemas and inheritance
In-Reply-To: <6d8daee30605231754s58364cd1o79a6520f203a1734@mail.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