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

From Dimitri
Subject Re: Any better plan for this query?..
Date
Msg-id 5482c80a0905060731h7d561ef0nc68cf782f8125815@mail.gmail.com
Whole thread Raw
In response to Re: Any better plan for this query?..  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
I supposed in case with prepare and then execute a query optimizer is
no more coming in play on "execute" phase, or did I miss something?..

Forget to say: query cache is disabled on MySQL side.

Rgds,
-Dimitri

On 5/6/09, Craig Ringer <craig@postnewspapers.com.au> wrote:
> Dimitri wrote:
>> Hi Chris,
>>
>> the only problem I see here is it's 2 times slower vs InnoDB, so
>> before I'll say myself it's ok I want to be sure there is nothing else
>> to do.. :-)
>
> Can the genetic query optimizer come into play on small queries?
>
> --
> Craig Ringer
>

pgsql-performance by date:

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