Re: PostgreSQL Write Performance

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(at)anarazel(dot)de> wrote:

> From: Andres Freund <andres(at)anarazel(dot)de>
> Subject: Re: [GENERAL] PostgreSQL Write Performance
> To: pgsql-general(at)postgresql(dot)org
> Cc: "Yan Cheng Cheok" <yccheok(at)yahoo(dot)com>
> 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
>