I have a unique constraint on two columns of a supermassive table (est. 1.7
bn rows) that are the only way the table's ever queried - and it's
blindingly fast: 51ms to retrieve any single row even non-partitioned.
Anyway: Right now statistics on the two unique constrained columns are set
to 200 e
Thanks guys! I'm gonna try tuning the statistics back down to 10 on that
table and see what that does to the insertion rates. Oh and for Mark: Not
to worry - i'd actually tuned the stats there up myself awhile ago in an
experiment to see if -that- would've sped insertions some; back before i'd
h
