Thread: tblspaces integrated in new postgresql (version 8.0)

tblspaces integrated in new postgresql (version 8.0)

From
bill@uchicago.edu
Date:
Hi, I have downloaded the new postgresql (version 8.0 beta2) and I was
wondering what performance features I can take advantage of before I start
to dump my 3/4 terrabyte database into the new format.  More specifically
I am interested in tablespaces--what exactly is this feature, some sort of
organizational addition (?) and howcan I best take advantage of this....?
Anything else?

Thanks.

Re: tblspaces integrated in new postgresql (version 8.0)

From
Tom Lane
Date:
bill@uchicago.edu writes:
> I am interested in tablespaces--what exactly is this feature, some sort of
> organizational addition (?) and howcan I best take advantage of this....?

See
http://developer.postgresql.org/docs/postgres/manage-ag-tablespaces.html

It doesn't talk a lot yet about *why* you'd want to use this ...

            regards, tom lane