Hi Sergei,
4. Ingesting into indexed table, based on our tests, is a big no-no. It gets progressively worse as the table grows.
We have to better understand all the parameters here before deciding if we can effort turning off all indices. For instance it would be good to catch duplicates as soon as possible rather than deffer it. That means turning at least primary keys. We also need to test thoroughly speed of building indexes, as you saw this is going to dominate... One technique to speed this up is to separate index files from data files. Thanks for doing these tests Jacek _______________________________________________ LSST-data mailing list [email protected] http://www.lsstmail.org/mailman/listinfo/lsst-data
