cancel
Showing results for 
Search instead for 
Did you mean: 

Move data to a different tablespace in PRODUCTION environment

SOLVED
Level 2 Adventurer

Re: Move data to a different tablespace in PRODUCTION environment

Hi,

 

Is it feasible to move columns to a tablespace ?

 

We generally move the LOB columns to a different tablespace. 

 

What are your thoughts on it ?

Highlighted
EDB Team Member

Re: Move data to a different tablespace in PRODUCTION environment

Hi @neiljo10,

 

In Postgres, you can keep the tables and indexes to different tablespaces and not the particular column.

 

The better way is to have the heavily used indexes, in your case LOB column indexes to separate tablespace which will be on fast SSD drives.

 

Regards,

Sudhir

Level 2 Adventurer

Re: Move data to a different tablespace in PRODUCTION environment

Hi @slonkar 

 

In Oracle the query is something like,

 

alter table TBL1 move lob (BLOB column) store as (tablespace TBSP1);

 

I hope I am correct when stating that this command is moving a table's column to a tablespace.

 

I want something like this to happen in PostGres, is there any query or method to do it ?

EDB Team Member

Re: Move data to a different tablespace in PRODUCTION environment

Hi @neiljo10,

 

We cannot move single column to the tablespace, its only applicable to tables and indexes. We can only move the tables and indexes on the tablespaces.

 

Regards,

Sudhir