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

From: Yan Cheng CHEOK <yccheok(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Date: 2010-05-17 01:21:09
Message-ID: 279207.89949.qm@web65715.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-05-17 02:15:16 Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Previous Message Tim Landscheidt 2010-05-17 00:21:01 Re: last and/or first in a by group