On Sun, May 16, 2010 at 7:21 PM, Yan Cheng CHEOK <yccheok@xxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
