From: PFC <lists@peufeu.com>
To: ryan groth <postgres@cpusoftware.com>
To: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Steinar H. Gunderson <sgunderson@bigfoot.com>
To: pgsql-performance@postgresql.org
Subject: Re: Joins and full index scans...mysql vs postgres?
Date: Thu, 23 Feb 2006 00:18:58 +0100
Message-ID: <op.s5edpwbncigqcu@apollo13> (raw)
In-Reply-To: <E1FBz6X-0007Do-9z@zeus.liquidweb.com>
References: <E1FBz6X-0007Do-9z@zeus.liquidweb.com>
> "997+3522 ms". Am I reading these numbers wrong? Are these numbers
> reflective of application performance? Is there an optimization I am
> missing?
It also reflects the time it takes to pgadmin to insert the results into
its GUI...
If you want to get an approximation of the time the server needs to
process your request, without the data marshalling time on the network and
anything, you can either use EXPLAIN ANALYZE (but mysql doesn't have it,
and the instrumentation adds overhead), or simply something like "SELECT
sum(1) FROM (query to benchmark)", which only returns 1 row, and the sum()
overhead is minimal, and it works on most databases. I find it useful
because in knowing which portion of the time is spent by the server
processing the query, or in data transfer, or in data decoding on the
client side, or simply in displaying...
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: lists@peufeu.com, postgres@cpusoftware.com, sszabo@megazone.bigpanda.com, sgunderson@bigfoot.com
Subject: Re: Joins and full index scans...mysql vs postgres?
In-Reply-To: <op.s5edpwbncigqcu@apollo13>
* 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