10.000 INSERTS (with multiple index)

............................................................................................................................................................................................................................................................................................................................................................

PostgreSQL 35.207sec
MySQL 3.222sec
  35.207 - 3.222 = 31.985
  10.92 times
MySQL faster than PostgreSQL
   
CREATE TABLE t2(a INTEGER, b INTEGER, c INTEGER, b1 VARCHAR(100), c1 VARCHAR(255));
CREATE INDEX i1 ON t2(a);
CREATE INDEX i2 ON t2(b);
CREATE INDEX i3 ON t2(c);
CREATE INDEX i4 ON t2(b1);
CREATE INDEX i5 ON t2(c1);

INSERT INTO t2 VALUES(1,986,352053,'nine hundred and eighty-six','three hundred and fifty-two thousand and fifty-three')
INSERT INTO t2 VALUES(2,223,694113,'two hundred and twenty-three','six hundred and ninety-four thousand one hundred and thirteen')
INSERT INTO t2 VALUES(3,748,357217,'seven hundred and fourty-eight','three hundred and fifty-seven thousand two hundred and seventeen')
INSERT INTO t2 VALUES(4,392,505038,'three hundred and ninety-two','five hundred and five thousand and thirty-eight')
..................
INSERT INTO t2 VALUES(19997,991,292507,'nine hundred and ninety-one','two hundred and ninety-two thousand five hundred and seven')
INSERT INTO t2 VALUES(19998,820,404293,'eight hundred and twenty','four hundred and four thousand two hundred and ninety-three')
INSERT INTO t2 VALUES(19999,546,188687,'five hundred and fourty-six','one hundred and eighty-eight thousand six hundred and eighty-seven')
INSERT INTO t2 VALUES(20000,810,471859,'eight hundred and ten','four hundred and seventy-one thousand eight hundred and fifty-nine')

 

<<back