Hi, On 8 January 2012 01:52, Jason Buberel <[email protected]> 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 ([email protected]) -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
