Postgres Pro
Downloads
Home   >   mailing lists

Why Performance of SQL Query is *much* Slower in GUI PgAdmin - Mailing list pgsql-general

From Yan Cheng CHEOK
Subject Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Date
Msg-id 279207.89949.qm@web65715.mail.ac4.yahoo.com
Whole thread Raw
Responses 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>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Tim Landscheidt
Date:
Subject: Re: last and/or first in a by group
Next
From: Tom Lane
Date:
Subject: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin