Re: Any better plan for this query?..

Поиск
Список
Период
Сортировка
От Dimitri
Тема Re: Any better plan for this query?..
Дата
Msg-id 5482c80a0905190324r3173b90cxb1b4288821f8991a@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Any better plan for this query?..  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Any better plan for this query?..
Следующее
От: Dimitri
Дата:
Сообщение: Re: Any better plan for this query?..