Re: Improving avg performance for numeric - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Improving avg performance for numeric
Date
Msg-id 6095.1363710347@sss.pgh.pa.us
Whole thread Raw
In response to Re: Improving avg performance for numeric  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: Improving avg performance for numeric  (Hadi Moshayedi <hadi@moshayedi.net>)
List 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 by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Improving avg performance for numeric
Next
From: Hadi Moshayedi
Date:
Subject: Re: Improving avg performance for numeric