From: tv@fuzzy.cz
To: Corin <wakathane@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: mysql to postgresql, performance questions
Date: Thu, 18 Mar 2010 15:50:53 +0100 (CET)
Message-ID: <57784.193.179.187.70.1268923853.squirrel@sq.gransy.com> (raw)
In-Reply-To: <4BA23936.2030507@gmail.com>
References: <4BA23936.2030507@gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tv@fuzzy.cz, wakathane@gmail.com
Subject: Re: mysql to postgresql, performance questions
In-Reply-To: <57784.193.179.187.70.1268923853.squirrel@sq.gransy.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox