PostgreSQL Write Performance
От | Yan Cheng Cheok |
---|---|
Тема | PostgreSQL Write Performance |
Дата | |
Msg-id | 707105.14949.qm@web65702.mail.ac4.yahoo.com обсуждение исходный текст |
Ответы |
Re: PostgreSQL Write Performance
Re: PostgreSQL Write Performance |
Список | pgsql-general |
I am not sure whether I am doing the correct benchmarking way. I have the following table ; CREATE TABLE measurement_type ( measurement_type_id bigserial NOT NULL, measurement_type_name text NOT NULL, CONSTRAINT pk_measurement_type_id PRIMARY KEY (measurement_type_id), CONSTRAINT measurement_type_measurement_type_name_key UNIQUE (measurement_type_name) ) I make the following single write operation through pgAdmin : INSERT INTO measurement_type ( measurement_type_name ) VALUES('Width'); It takes 16ms to write a single row according to "Query Editor" (bottom right corner) Am I doing the correct way to benchmarking? I am not sure whether this is expected performance? For me, I am expecting thetime measurement is in nano seconds :p Thanks and Regards Yan Cheng CHEOK
В списке pgsql-general по дате отправления: