Re: Any better plan for this query?.. - Mailing list pgsql-performance

From Richard Huxton
Subject Re: Any better plan for this query?..
Date
Msg-id 4A015225.9000903@archonet.com
Whole thread Raw
In response to Re: Any better plan for this query?..  (Dimitri <dimitrik.fr@gmail.com>)
List 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

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Any better plan for this query?..
Next
From: Matthew Wakeling
Date:
Subject: Re: Any better plan for this query?..