Re: TableSpace Design issues on Postgres 8.0 beta 5

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rosny" <sehatrosny(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: TableSpace Design issues on Postgres 8.0 beta 5
Date: 2004-12-07 04:44:36
Message-ID: 10164.1102394676@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Rosny" <sehatrosny(at)hotmail(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-12-07 05:03:56 Re: Config Check
Previous Message Christopher Browne 2004-12-07 04:17:24 Re: scaling beyond 4 processors