The performance seems low...

Open didip opened this issue 3 years ago • 2 comments

I modified the million benchmark to billion and it took forever to insert.

Is it possible to expand the commit.Buffer to speed up the transaction?

Dec 04 '22 21:12 didip

Hello, I also noticed a very high bump in insert-time-per-record when bumping amount to 1B from 10M (as in, more than 100x time for 100x records). While the mass-loading pattern doesn't exactly complement a store built for concurrent DML, I agree the 1B benchmark should insert in a reasonable time regardless - especially with all data being known before hand.

Dec 07 '22 18:12 Dreeseaw

Indeed, insertion is a bit slow as it touches most columns. I have a few questions to clarify this.

How did you perform the insertion (single or multiple txn)?
What was the time to insert 1B?
What's the expected time?

Dec 12 '22 06:12 kelindar