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 ?
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.
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 ?
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.
A database's data is collectively stored in the datafiles that constitute each tablespace of the database. need help for example, the simplest Oracle and sap database would have one tablespace and one datafile. Another database can have three tablespaces, each consisting of two datafiles in better ways
Thanks for tips.