\timing on
Timing is on.
\set num_rows 100000
drop table if exists test_thai;
DROP TABLE
Time: 36.125 ms
create table test_thai(id serial, data text);
CREATE TABLE
Time: 29.668 ms
insert into test_thai (data) select 'อัญประกาศ' || i::text from generate_series(1,:num_rows) as t(i);
INSERT 0 100000
Time: 151.709 ms
truncate test_thai ;
TRUNCATE TABLE
Time: 16.857 ms
create index test_thai_data on test_thai(data);
CREATE INDEX
Time: 12.381 ms
insert into test_thai (data) select 'русский' || i::text from generate_series(1,:num_rows) as t(i);
INSERT 0 100000
Time: 676.143 ms
truncate test_thai ;
TRUNCATE TABLE
Time: 26.376 ms
insert into test_thai (data) select '汉字/漢字' || i::text from generate_series(1,:num_rows) as t(i);
INSERT 0 100000
Time: 1161.516 ms (00:01.162)
truncate test_thai ;
TRUNCATE TABLE
Time: 22.561 ms
insert into test_thai (data) select 'อัญประกาศ' || i::text from generate_series(1,:num_rows) as t(i);
INSERT 0 100000
Time: 58234.397 ms (00:58.234)