Re: Inserts and bad performance

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 11/24/21 1:15 PM, Godfrin, Philippe E wrote:

    [snip]

I dropped the unique index , rebuilt the other indexes and no change.

    IMNSHO, this is the worst possible approach.  Drop everything except
    the unique index, and then (if possible) sort the input file by the
    unique key.   That'll increase buffered IO; otherwise, you're
    bopping all around the filesystem.
    
    Using a bulk loader if possible would increase speeds

--
Angular momentum makes the world go 'round.