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@xxxxxxxxxxxx> wrote: > From: Guillaume Lelarge <guillaume@xxxxxxxxxxxx> > Subject: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin > To: "Yan Cheng CHEOK" <yccheok@xxxxxxxxx> > Cc: pgsql-general@xxxxxxxxxxxxxx > 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
