| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | James Sewell <james(dot)sewell(at)lisasoft(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Random note of encouragement |
| Date: | 2016-02-24 23:26:15 |
| Message-ID: | 20160224232615.GA14651@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)momjian(dot)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 +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2016-02-24 23:50:06 | Re: Random note of encouragement |
| Previous Message | James Sewell | 2016-02-24 23:06:34 | Random note of encouragement |