poniedziałek, 14 maja 2012

Move table to another tablespace in Postgresql

dbtest# \t
dbtest# \o dbtest_tablespace.txt
dbtest# select 'alter table '||tablename||' set tablespace temporary_tablespace;' from pg_tables where tablename like 'example%';
dbtest# select 'alter index '||indexname||'  set tablespace temporary_tablespace;' from pg_indexes where tablename like 'example%';
dbtest# \i dbtest_tablespace.txt

środa, 2 maja 2012

FusionIO kernel linux 3.2 patch

Recently I've got problems with fusionIO and linux new kernel because fusionIO doesn't support new kernels (> 2.6). Below is patch for kernel 3.2 ( I think it should work on 3.x too). FusionIO kernel patch