Message-ID: <57784.193.179.187.70.1268923853.squirrel@sq.gransy.com>
In-Reply-To: <4BA23936.2030507@gmail.com>
References: <4BA23936.2030507@gmail.com>
Date: Thu, 18 Mar 2010 15:50:53 +0100 (CET)
Subject: Re: mysql to postgresql, performance questions
From: tv@fuzzy.cz
To: "Corin" <wakathane@gmail.com>
Cc: pgsql-performance@postgresql.org
User-Agent: SquirrelMail/1.4.10a
MIME-Version: 1.0
Content-Type: text/plain;charset=iso-8859-2
Content-Transfer-Encoding: 8bit
Importance: Normal

I guess we need some more details about the test. Is the
connection/disconnection part of each test iteration? And how are the
databases connected (using a socked / localhost / different host)?

Anyway measuring such simple queries will tell you almost nothing about
the general app performance - use the queries that are used in the
application.

> I also wonder why the reported runtime of 5.847 ms is so much different
> to the runtime reported of my scripts (both php and ruby are almost the
> same). What's the best tool to time queries in postgresql? Can this be
> done from pgadmin?

I doubt there's a 'best tool' to time queries, but I'd vote for logging
from the application itself, as it measures the performance from the end
user view-point (and that's what you're interested in). Just put some
simple logging into the database access layer.

regards
Tomas