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

From Scott Marlowe
Subject Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Date
Msg-id AANLkTimsvdDtXMWVd7s6YiRLRXpoJu5yWyOU5sfWk8iW@mail.gmail.com
Whole thread Raw
In response to Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin  (Thomas Kellerer <spam_eater@gmx.net>)
Responses Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
On Mon, May 17, 2010 at 2:35 AM, Thomas Kellerer <spam_eater@gmx.net> wrote:
> Yan Cheng CHEOK, 17.05.2010 03:21:
>>
>> 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.
>>
>
> Why on earth would anybody compare database performance using a command that
> is usually executed only once in the lifetime of a database?
>
> It's like saying "The car from manufacturer A is slower than the one from
> manufacturer B, because it takes 1 second longer to start the engine..."

I refer you to this classic post on the subject:
http://www.mail-archive.com/pgsql-general@postgresql.org/msg93043.html

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Next
From: Thomas Kellerer
Date:
Subject: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin