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

From Kevin Grittner
Subject Re: Improving avg performance for numeric
Date
Msg-id 1363707490.38208.YahooMailNeo@web162906.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: Improving avg performance for numeric  (Hadi Moshayedi <hadi@moshayedi.net>)
Responses Re: Improving avg performance for numeric  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: Improving avg performance for numeric  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hadi Moshayedi <hadi@moshayedi.net> wrote:

> I updated the patch by taking ideas from your patch, and unifying
> the transition struct and update function for different
> aggregates. The speed of avg improved even more. It now has 60%
> better performance than the current committed version.

Outstanding!

> 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?

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-hackers by date:

Previous
From: Kohei KaiGai
Date:
Subject: Re: Review of Row Level Security
Next
From: Pavel Stehule
Date:
Subject: Re: Improving avg performance for numeric