Re: Time to move table to new tablespace

Hi,

On 8 January 2012 01:52, Jason Buberel <jason(at)altosresearch(dot)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(dot)ivanic(at)gmail(dot)com)