Thanks for the information. I wrote a plan c program to test the performance. Its time measurement is very MUCH different from pgAdmin.
Thanks and Regards
Yan Cheng CHEOK
--- On Wed, 1/6/10, Andres Freund <andres@xxxxxxxxxxx> wrote:
> From: Andres Freund <andres@xxxxxxxxxxx>
> Subject: Re: PostgreSQL Write Performance
> To: pgsql-general@xxxxxxxxxxxxxx
> Cc: "Yan Cheng Cheok" <yccheok@xxxxxxxxx>
> Date: Wednesday, January 6, 2010, 6:49 AM
> Hi,
>
> On Tuesday 05 January 2010 04:36:10 Yan Cheng Cheok wrote:
>
> > I make the following single write operation through
> pgAdmin :
> ...
> > It takes 16ms to write a single row according to
> "Query Editor" (bottom
> > right corner)
> In my experience the times presented by pgadmin vary wildly
> and seldomly do
> represent an accurate timing.
>
> Andres
>
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
