Re: Random note of encouragement

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Random note of encouragement
Дата
Msg-id 20160224232615.GA14651@momjian.us
обсуждение исходный текст
Ответ на Random note of encouragement  (James Sewell <james.sewell@lisasoft.com>)
Ответы Re: Random note of encouragement  (Thomas Munro <thomas.munro@enterprisedb.com>)
Список 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 по дате отправления:

Предыдущее
От: James Sewell
Дата:
Сообщение: Random note of encouragement
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: Random note of encouragement