Re: Random note of encouragement - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Random note of encouragement
Date
Msg-id 20160224232615.GA14651@momjian.us
Whole thread Raw
In response to Random note of encouragement  (James Sewell <james.sewell@lisasoft.com>)
Responses Re: Random note of encouragement
List pgsql-hackers
On Thu, Feb 25, 2016 at 10:06:34AM +1100, James Sewell wrote:
> Now when I run the following SQL (multiple times to allow for getting
> everything into shared buffers, which is 4GB on my machine):
> 
> 
>     select sum(count_n) from base group by view_time_day;
> 
> 
> I get the following results:
> 
> 
>     PSQL 9.5 - ~21 seconds
>     PSQL 9.6 devel - ~8.5 seconds
> 
> 
> I think that's pretty good!
> 
> I know this is a devel release, things may change, blah blah. But still,
> something has changed for the better here!

Wow, that is cool.  Can anyone suggest which commit improved this?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription                             +



pgsql-hackers by date:

Previous
From: James Sewell
Date:
Subject: Random note of encouragement
Next
From: Thomas Munro
Date:
Subject: Re: Random note of encouragement