Hi,
On 8 January 2012 01:52, Jason Buberel <jason@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.ivanic@gmail.com)
