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

2010-05-17 Thread Guillaume Lelarge
Le 17/05/2010 07:52, Yan Cheng CHEOK a écrit : > The pgadmin result seems different with my machine. My friend and I are using > Windows machine. Are you using Linux machine? > My tests this morning were on a Linux machine. I tried tonight with a Windows PC. Here are the results for three "creat

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

2010-05-17 Thread Justin Graf
On 5/17/2010 12:52 AM, Yan Cheng CHEOK wrote: > The pgadmin result seems different with my machine. My friend and I are using > Windows machine. Are you using Linux machine? > > Thanks and Regards > Yan Cheng CHEOK > > > **snip** I use both windows and Linux using pgadmin, and on occasion use

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

2010-05-17 Thread Scott Marlowe
On Mon, May 17, 2010 at 12:02 AM, Scott Marlowe wrote: > On Sun, May 16, 2010 at 7:21 PM, Yan Cheng CHEOK 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

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

2010-05-17 Thread Thomas Kellerer
Scott Marlowe, 17.05.2010 10:58: 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

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

2010-05-17 Thread Scott Marlowe
On Mon, May 17, 2010 at 2:35 AM, Thomas Kellerer 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 creat

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

2010-05-17 Thread Thomas Kellerer
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 perfor

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

2010-05-17 Thread Scott Marlowe
Here's a more useful test. write a simple script that creates a 100 or so dbs. Run it against each database, and while it's running, pull the power plug. Plug back in, see if your database comes back up uncorrupted. If pgsql is on proper db hardware (i.e. it obeys fsync, has battery backed cach

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

2010-05-16 Thread Scott Marlowe
On Sun, May 16, 2010 at 7:21 PM, Yan Cheng CHEOK 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 thro

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

2010-05-16 Thread Yan Cheng CHEOK
The pgadmin result seems different with my machine. My friend and I are using Windows machine. Are you using Linux machine? Thanks and Regards Yan Cheng CHEOK --- On Mon, 5/17/10, Guillaume Lelarge wrote: > From: Guillaume Lelarge > Subject: Re: [GENERAL] Why Performance of SQL Qu

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

2010-05-16 Thread Guillaume Lelarge
Le 17/05/2010 03:21, Yan Cheng CHEOK a écrit : > 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 pgad

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

2010-05-16 Thread Tom Lane
Yan Cheng CHEOK 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 appro

[GENERAL] Why Performance of SQL Query is *much* Slower in GUI PgAdmin

2010-05-16 Thread Yan Cheng CHEOK
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 comm