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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 02:15:16
Message-ID: 2934.1274062516@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Yan Cheng CHEOK <yccheok(at)yahoo(dot)com> writes:
> 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.

Just for the record, CREATE DATABASE in postgres has approximately
nothing to do with CREATE DATABASE in mysql --- the latter is more or
less equivalent to what we call CREATE SCHEMA. So if you're going to
form speed impressions based on just this one operation, try comparing
those two commands.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ken Winter 2010-05-17 03:17:34 'Infinity' in date columns?
Previous Message Yan Cheng CHEOK 2010-05-17 01:21:09 Why Performance of SQL Query is *much* Slower in GUI PgAdmin