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

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Yan Cheng CHEOK <yccheok(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Date: 2010-05-17 05:22:39
Message-ID: 4BF0D29F.6010800@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yan Cheng CHEOK 2010-05-17 05:52:42 Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Previous Message Tom Lane 2010-05-17 04:21:57 Re: 'Infinity' in date columns?