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

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