Re: Improving avg performance for numeric

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Improving avg performance for numeric
Дата
Msg-id 6095.1363710347@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Improving avg performance for numeric  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: Improving avg performance for numeric  (Hadi Moshayedi <hadi@moshayedi.net>)
Список pgsql-hackers
Kevin Grittner <kgrittn@ymail.com> writes:
> Hadi Moshayedi <hadi@moshayedi.net> wrote:
>> I also noticed that this patch makes matview test fail. It seems
>> that it just changes the ordering of rows for queries like
>> "SELECT * FROM tv;". Does this seem like a bug in my patch, or
>> should we add "ORDER BY" clauses to this test to make it more
>> deterministic?

> I added some ORDER BY clauses.� That is probably a good thing
> anyway for purposes of code coverage.� Does that fix it for you?

Uh, what?  Fooling around with the implementation of avg() should surely
not change any planning decisions.
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Improving avg performance for numeric
Следующее
От: Hadi Moshayedi
Дата:
Сообщение: Re: Improving avg performance for numeric