From: Rosny <sehatrosny@hotmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: TableSpace Design issues on Postgres 8.0 beta 5
Date: Mon, 6 Dec 2004 23:58:06 -0800
Message-ID: <cp3nqc$27fl$1@news.hub.org> (raw)
References: <cp1o7f$13ad$2@news.hub.org>
<10164.1102394676@sss.pgh.pa.us>
Thanks for the response.
I just start to get a feel of where TableSpace will be used. You are right I
do not have 7000 logical filesystems.
I am assuming using TableSpace as organization of files in folders in
Windows 2003 Environment. So, each
TableSpace will represent one folder(directory) in a drive. But this doesnot
work to well for my design.
Since pgAdmin III GUI take 2 hours just to load approximately 14000 tables.
I am not using TableSpace approach anymore. I am using multiple database
approach.
Anyway, thanks for the response. Today testing by taking several option to
the limit. I kind of having some ideas
for future scability.
Rosny
"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:10164.1102394676@sss.pgh.pa.us...
> "Rosny" <sehatrosny@hotmail.com> writes:
> > B. For each department create tablespace. (Which means, if there
> > are 7000 departments, there will be 7000 tablespace each contains
> > 20 tables).
>
> If your system has seven thousand separate logical filesystems attached
> to it, there might be some value in having seven thousand tablespaces.
> But I will bet a great deal that it does not and there isn't.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
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-performance@postgresql.org
Cc: sehatrosny@hotmail.com
Subject: Re: TableSpace Design issues on Postgres 8.0 beta 5
In-Reply-To: <cp3nqc$27fl$1@news.hub.org>
* 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