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. # #================================================== [EMAIL PROTECTED] # _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
