[PERFORM] tblspaces integrated in new postgresql (version 8.0)
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)
[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