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

From Dimitri
Subject Re: Any better plan for this query?..
Date
Msg-id 5482c80a0905190324r3173b90cxb1b4288821f8991a@mail.gmail.com
Whole thread Raw
In response to Re: Any better plan for this query?..  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
No, Tom,  the query cache was off.
I put it always explicitly off on MySQL as it has scalability issues.

Rgds,
-Dimitri

On 5/19/09, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
>> In particular, running the tests repeatedly using
>>     H.REF_OBJECT = '0000000001'
>> rather than varying the value seems likely to benefit MySQL.
>
> ... mumble ... query cache?
>
>             regards, tom lane
>

pgsql-performance by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Any better plan for this query?..
Next
From: Dimitri
Date:
Subject: Re: Any better plan for this query?..