Postgres Pro
Downloads
Home   >   mailing lists

Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin - Mailing list pgsql-general

From Guillaume Lelarge
Subject Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin
Date
Msg-id 4BF1BE00.7050400@lelarge.info
Whole thread Raw
In response to Re: Why Performance of SQL Query is *much* Slower in GUI PgAdmin  (Yan Cheng CHEOK <yccheok@yahoo.com>)
List pgsql-general
Tree view 
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 "create database":

pgAdmin: 7.6s ; 8.5s ; 7.6s
psql:    6.8s ; 7.4s ; 7.4s

Not much of a difference either (between the GUI tool (pgAdmin) and the
CLI tool (psql)). But a really big one between Linux and Windows.

PG 8.4.4, pgAdmin 1.12b1+ (both on Linux and Windows).


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: pg_dumpall custom format?
Next
From: Thom Brown
Date:
Subject: Re: Fwd: Google Alert - postgresql 8.4