On 25 October 2012 19:46, Boris Epstein <borepstein@xxxxxxxxx> wrote: > And if I want to split the storage - i.e., put databases into different > directories - can I do that? Take a look at the tablespace feature: http://www.postgresql.org/docs/current/static/sql-createtablespace.html You can move existing tables with ALTER TABLE (likewise for indexes), and change the default for new tables created in future in a database with ALTER DATABASE: http://www.postgresql.org/docs/9.2/static/sql-altertable.html http://www.postgresql.org/docs/9.2/static/sql-alterdatabase.html Before the tablespace feature was added, people used to create symlinks in the data directory if they wanted to use different storage for different objects (say, a special fast disk array for certain data). The tablespace feature actually works the same way, but it's managed for you via DDL commands. Hope that helps, Thomas -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
