"Rosny" <> 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