On Fri, Aug 1, 2008 at 4:16 PM, David Wilson <david.t.wilson@xxxxxxxxx> wrote: > On Fri, Aug 1, 2008 at 4:07 PM, Alex Vinogradovs > <AVinogradovs@xxxxxxxxxxxxxxxx> wrote: >> By loading in bulks, I mean I load some 40-50 thousand >> rows at once into a table that already has some millions. >> Index rebuild on that table after each 50k inserts will >> be even less efficient ;) > > How many indexes do you have on this...? I do this pretty regularly > (actually, I do 4k batches with COPY, 4-10 concurrent batches every 10 > seconds, for 2-3 days at a time) and, having testing dropping indices, > nothing to do with the index has a particularly strong performance > impact. Sorry, as I hit send, I realized I should clarify this: I do my bulk loads with the indexes active; I don't rebuild them (as they're necessary during the batch calculations). Dropping the indexes and using test data didn't show a significant performance improvement over leaving the indexes enabled. -- - David T. Wilson david.t.wilson@xxxxxxxxx
