[PERFORM] tblspaces integrated in new postgresql (version 8.0)

2004-09-13 Thread bill
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.

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [PERFORM] tblspaces integrated in new postgresql (version 8.0)

2004-09-13 Thread Tom Lane
[EMAIL PROTECTED] 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

---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings