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
>