Hi, On 8 January 2012 01:52, Jason Buberel <ja...@altosresearch.com> wrote: > psql> create tablespace 'newstorage' location '/some/new/path'; > psql> alter table city_summary set tablespace = 'newstorage';
Be aware that you are not going to move indexes (see ALTER INDEX name SET TABLESPACE tablespace_name). Maybe you don't have to move data and I would be worth to move indexes only. So you ended up with data and index tablespace and reduce random_page_cost when you query your table. -- Ondrej Ivanic (ondrej.iva...@gmail.com) -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
