MySQL and PostgreSQL small pk

General additions and deletions to search

The table structure and data are extremely simple, and the naming is also not fastidious. Is the default configuration, MySQL table default InnoDB engine. Table x contains three int fields a B c,100w data are a=1 b=2 c=3

SQL statements

Build table:

Create Table int int int);

Insert data (Import from text):

--MySQL
Loadintotable x;
--PG
From ' Data.txt ';

Querying data

Select *  from where = 2;

Update data:

Update Set = 4 where = 2;

Delete data:

Delete  from X;

Data comparison

	Mysql	Pg	Contrast
insertx100w	2.8~3.5s	500~600ms	PG Speed is MYSQL5 times
Select	250ms	63ms	PG Speed is MYSQL4 times
Update	370ms	78ms	PG Speed is mysql4.7 times
Delete	4~5s	1.8~2.5ms	PG Speed is MYSQL2 times

Not finished ... "may" be continued (more level of comparison) ...

MySQL and PostgreSQL small pk