golang 不同方式插入postgres比较
Description:
- 常规插入: 28.855439529s
- 事物循环插入: 15.848329755s
- pg copy 插入: 37.207166ms
Example:
package main
import (
"database/sql"
"fmt"
_ "github.com/lib/pq"
"time"
"github.com/lib/pq"
"strconv"
)
const (
host = "localhost"
port = 5432
user = "root"
password = "public"
dbname = "test"
)
func Connect()(*sql.DB){
psqlInfo := fmt.Sprintf("host=%s port=%d user=%s "+
"password=%s dbname=%s sslmode=disable",
host, port, user, password, dbname)
db, err := sql.Open("postgres", psqlInfo)
if err != nil {
panic(err)
}
err = db.Ping()
if err != nil {
panic(err)
}
fmt.Println(