Create large random dataset in PostgreSQL

Create large ~1 GB random dataset in PostgreSQL

hansamu 08/27/2019

Chạy SQL sau để gen data lớn cho postgres

CREATE TABLE large_test (num1 bigint, num2 double precision, num3 double precision);

INSERT INTO large_test (num1, num2, num3)
  SELECT round(random()*10), random(), random()*142
  FROM generate_series(1, 20000000) s(i);

CREATE TABLE large_test (num1 bigint, num2 double precision, num3 double precision);

INSERT INTO large_test (num1, num2, num3)

SELECT round(random()*10), random(), random()*142

FROM generate_series(1, 20000000) s(i);

DevOps VN

DevOps là phải lười ~_~

Create large random dataset in PostgreSQL

Create large ~1 GB random dataset in PostgreSQL