Thanks for the information. I wrote a plan c program to test the performance. Its time measurement is very MUCH
differentfrom pgAdmin.
Thanks and Regards
Yan Cheng CHEOK
--- On Wed, 1/6/10, Andres Freund <andres@anarazel.de> wrote:
> From: Andres Freund <andres@anarazel.de>
> Subject: Re: [GENERAL] PostgreSQL Write Performance
> To: pgsql-general@postgresql.org
> Cc: "Yan Cheng Cheok" <yccheok@yahoo.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
>