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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
