On Tue, 2007-09-04 at 07:49 +0300, Mikko Partio wrote: > > No (changing tablespaces does not change your logical schema). I just tested this "feature" with a temp table and it works as advertised. (In progress of moving a table there now actually) 2nd question.. reading the docs, it says that moving a table doesn't imply that the corresponding table's indexes are also moved to a that same tablespace. eg: dbspace2 alter table foo set tablespace dbspace2; how do I move the indexes to that space space? I tried using pgadmin3 (1.4.3) but the option to move the index to another tablespace is greyed out. hmm.. forget the question.. seems like this works.. so I'm posting it to be archived in the list. alter table idx_foo_value set tablespace dbspace2 works. This is missing in the docs (afaict) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
