On Thu, Feb 25, 2016 at 1:43 PM, Bruce Momjian wrote:
> On Thu, Feb 25, 2016 at 12:50:06PM +1300, Thomas Munro wrote:
>> On Thu, Feb 25, 2016 at 12:26 PM, Bruce Momjian wrote:
>> > On Thu, Feb 25, 2016 at 10:06:34AM +1100, James Sewell wrote:
>> >> Now when I run the following SQL (multiple times
On Thu, Feb 25, 2016 at 12:50:06PM +1300, Thomas Munro wrote:
> On Thu, Feb 25, 2016 at 12:26 PM, Bruce Momjian wrote:
> > 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, w
Argh seems like a false alarm for now.
I installed 9.5 from RPM source (the other was one I had installed
previously) and the performance matched 9.6
Sorry about that, I must have *something* screwed up on the other one.
Cheers,
James Sewell,
PostgreSQL Team Lead / Solutions Architect
On 25 February 2016 at 12:50, Thomas Munro
wrote:
> On Thu, Feb 25, 2016 at 12:26 PM, Bruce Momjian wrote:
>> On Thu, Feb 25, 2016 at 10:06:34AM +1100, James Sewell wrote:
>>> I get the following results:
>>>
>>>
>>> PSQL 9.5 - ~21 seconds
>>> PSQL 9.6 devel - ~8.5 seconds
>>>
>>>
>>> I t
I've actually just tested this on 9.3 - and I get roughly the same as
9.6devel.
Now going back to make sure my 9.5 environment is sane.
Hopefully this isn't me jumping the gun.
Cheers,
James Sewell,
PostgreSQL Team Lead / Solutions Architect
__
Level 2, 50
On Thu, Feb 25, 2016 at 12:26 PM, Bruce Momjian wrote:
> 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
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:
Hey All,
I've been doing some (futile) work trying to speed up aggregates with a
group by in PostgreSQL 9.5.
I installed PostgreSQL 9.6 on the same machine to see if I could get
anything running in parallel when using partitioning - which didn't work.
But - I did find this:
With the following s