Hi,
On 04/23/15 14:33, John McKown wrote:
That's a really old release. But I finally found some doc on it. And
8.4 does appear to have TABLESPACEs in it.
http://www.postgresql.org/docs/8.4/static/manage-ag-tablespaces.html
<quote>
To define a tablespace, use the CREATE TABLESPACE
<http://www.postgresql.org/docs/8.4/static/sql-createtablespace.html> command,
for example::
CREATE TABLESPACE fastspace LOCATION '/mnt/sda1/postgresql/data';
The location must be an existing, empty directory that is owned by the
PostgreSQL system user. All objects subsequently created within the
tablespace will be stored in files underneath this directory.
I think you should read this:
http://thebuild.com/blog/2013/03/10/you-cannot-recover-from-the-loss-of-a-tablespace/
in other words, using tablespaces for placing some of the data into a
RAM filesystem (which may disappear) is a rather terrible idea. In case
of crash you won't be able to even start the database, because it will
try to recover the tablespace.
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
