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

Поиск
Список
Период
Сортировка
От Yan Cheng CHEOK
Тема Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Дата
Msg-id 279207.89949.qm@web65715.mail.ac4.yahoo.com
обсуждение исходный текст
Ответы Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin  (Guillaume Lelarge <guillaume@lelarge.info>)
Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
Дерево обсуждения 
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?

Thanks and Regards
Yan Cheng CHEOK

В списке pgsql-general по дате отправления:

Предыдущее
От: Tim Landscheidt
Дата:
Сообщение: Re: last and/or first in a by group
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin