PostgreSQL Write Performance - Mailing list pgsql-general

From Yan Cheng Cheok
Subject PostgreSQL Write Performance
Date
Msg-id 707105.14949.qm@web65702.mail.ac4.yahoo.com
Whole thread Raw
Responses Re: PostgreSQL Write Performance  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: PostgreSQL Write Performance  (Andres Freund <andres@anarazel.de>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: ERROR in createlang
Next
From: Scott Marlowe
Date:
Subject: Re: PostgreSQL Write Performance