Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin

The pgadmin result seems different with my machine. My friend and I are using Windows machine. Are you using Linux machine?

Thanks and Regards
Yan Cheng CHEOK

--- On Mon, 5/17/10, Guillaume Lelarge <guillaume(at)lelarge(dot)info> wrote:

> From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
> Subject: Re: [GENERAL] Why Performance of SQL Query is *much* Slower in GUI PgAdmin
> To: "Yan Cheng CHEOK" <yccheok(at)yahoo(dot)com>
> Cc: pgsql-general(at)postgresql(dot)org
> Date: Monday, May 17, 2010, 1:22 PM
> Le 17/05/2010 03:21, Yan Cheng CHEOK
> a écrit :
> > Recently, I try to introduce my friend to use
> PostgreSQL.
> >
> > However, he first impression is that. PostgreSQL is
> much slower compared to MySQL. He realize he has to wait for
> 7 seconds, to create a tmp database.
> >
> > He run a command through pgadmin GUI.
> >
> > "CREATE DATABASE TMP;"
> >
> > I try to run through command prompt instead. It tooks
> 2 seconds.
> >
> > May I know what is the reason, SQL query execution is
> *much* slower in GUI PgAdmin?
> >
>
> 593ms in pgAdmin, 562ms in psql. A bit slower, but not that
> much (in 8.4).
>
>
> --
> Guillaume.
> http://www.postgresqlfr.org
> http://dalibo.com
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>