On 6/9/2006 5:45 PM, Christopher Browne wrote:

> 2.  Load the data, and throw reindexing to a separate thread that might
> take place concurrently...
> 
>     for each table t
>        deactivate indexes on t
>        copy data for T
>        reactivate indexes on t
>        throw table t to reindexing thread
>    done

This won't work at all. Because the COPY thread's transaction isn't 
committed yet, any other connection won't see the data to index.


Jan

-- 
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck at Yahoo.com #