Re: Improving avg performance for numeric
| От | Hadi Moshayedi |
|---|---|
| Тема | Re: Improving avg performance for numeric |
| Дата | |
| Msg-id | CAK=1=Wpj2snL2XUU+15dQ_DozpF8JygjQ3uo_0AJ_A50D4Dxug@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Improving avg performance for numeric (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: Improving avg performance for numeric
|
| Список | pgsql-hackers |
I am not sure how this works, but I also changed numeric sum(), and the views in question had a numeric sum() column. Can that have any impact?
I am going to dig deeper to see why this happens.
On Tue, Mar 19, 2013 at 6:25 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> I also noticed that this patch makes matview test fail. It seemsUh, what? Fooling around with the implementation of avg() should surely
>> 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?
not change any planning decisions.
regards, tom lane
В списке pgsql-hackers по дате отправления: