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

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
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 06:02:18
Message-ID: AANLkTimPiqPaM2w7dWC09cQyVwz23tUL0DXU9ibe8biV@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sun, May 16, 2010 at 7:21 PM, Yan Cheng CHEOK <yccheok(at)yahoo(dot)com> wrote:
> 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.

Maybe he's running an older version that hasn't had create db
optimized? Maybe he's looking at exactly the wrong place to be
deciding which db is faster? Seriously, from the perspective of a DBA
with a db in the hundreds of gigabytes, how long it takes to create an
empty one is exactly 0% interesting to me, unless it somehow becomes
minutes or something weird, which it hasn't.

How well a db runs with hundreds of active connections and queries,
and running complex operations is interesting. This? Not so much.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Catalin BOIE 2010-05-17 06:09:03 Re: PANIC: corrupted item pointer: 32766
Previous Message Catalin BOIE 2010-05-17 05:58:03 Re: PANIC: corrupted item pointer: 32766