Re: Any better plan for this query?..

From: Richard Huxton <dev(at)archonet(dot)com>
To: Dimitri <dimitrik(dot)fr(at)gmail(dot)com>
Cc: Chris <dmagick(at)gmail(dot)com>, Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Any better plan for this query?..
Date: 2009-05-06 09:02:29
Message-ID: 4A015225.9000903@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Dimitri wrote:
> Hi Richard,
>
> no, of course it's not based on explain :-)
> I've run several tests before and now going in depth to understand if
> there is nothing wrong. Due such a single query time difference InnoDB
> is doing 2-3 times better TPS level comparing to PostgreSQL..

And you are satisfied that it is the planned query time that is the
dominant factor here, and not parsing time, connection time, data
transport, disk bandwidth etc?

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Matthew Wakeling 2009-05-06 09:35:50 Re: Any better plan for this query?..
Previous Message Dimitri 2009-05-06 08:49:32 Re: Any better plan for this query?..