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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Date: 2010-05-17 08:58:30
Message-ID: AANLkTimsvdDtXMWVd7s6YiRLRXpoJu5yWyOU5sfWk8iW@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, May 17, 2010 at 2:35 AM, Thomas Kellerer <spam_eater(at)gmx(dot)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(at)postgresql(dot)org/msg93043.html

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2010-05-17 09:19:12 Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Previous Message Thomas Kellerer 2010-05-17 08:35:59 Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin