Re: [GENERAL] Side effects of moving an index to a new tablespace

2012-01-10 Thread Sergey Konoplev
2012/1/10 Ondrej Ivanič : >> One area where the documentation is not very detailed - What are the side >> effects and/or constraints put in place while an index is being moved? I >> assume that the index will not be available to the query planner/engine >> during that time period. Are there other w

Re: [GENERAL] Side effects of moving an index to a new tablespace

2012-01-09 Thread Ondrej Ivanič
Hi, On 10 January 2012 09:16, Jason Buberel wrote: > We have lots of them, they are much smaller than the tables, and that will > allow us to do the migrations more incrementally. In your case I would keep data and indexes on different table spaces (and lower random_page_cost). > One area where

[GENERAL] Side effects of moving an index to a new tablespace

2012-01-09 Thread Jason Buberel
As per Ondrej's suggestion, our current thinking/planning at this point is to move indices instead of tables. We have lots of them, they are much smaller than the tables, and that will allow us to do the migrations more incrementally. One area where the documentation is not very detailed - What a