pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Noah Silverman <noah@allresearch.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Multiple databases one directory
Date: Fri, 24 Jan 2003 19:50:24 -0500
Message-ID: <27964.1043455824@sss.pgh.pa.us> (raw)
In-Reply-To: <BAD36AF8-2FEC-11D7-A3A3-000393AA8F3C@allresearch.com>
References: <BAD36AF8-2FEC-11D7-A3A3-000393AA8F3C@allresearch.com>

Noah Silverman <noah@allresearch.com> writes:
> We have a situation where we will be creating two fairly large and 
> complex databases with many tables (thousands) each.  From what I 
> understand, postgres keeps everything in one big data directory.

Yeah.  You're kind of at the mercy of the operating system when you do
that: if it copes well with big directories, no problem, but if lookups
in big directories are slow then you'll take a performance hit.

The first thing I'd ask is *why* you think you need thousands of
tables.  How will you keep track of them?  Are there really thousands of
different table schemas?  Maybe you can combine tables by introducing
an extra key column.

Perhaps a little bit of rethinking will yield a small design screaming
to get out of this big one ...

			regards, tom lane



view thread (4+ messages)  latest in thread

Message-ID: <27964.1043455824@sss.pgh.pa.us>
Permalink:  ../27964.1043455824@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/27964.1043455824@sss.pgh.pa.us

 · 

reply

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: tgl@sss.pgh.pa.us, noah@allresearch.com
  Subject: Re: Multiple databases one directory
  In-Reply-To: <27964.1043455824@sss.pgh.pa.us>
  References: <BAD36AF8-2FEC-11D7-A3A3-000393AA8F3C@allresearch.com> <27964.1043455824@sss.pgh.pa.us>

* 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