Re: Testing Postgresql 9.5 RC1 with Alfresco 5.0.d

Simon Riggs wrote on 29/12/15 05:31:
[...]
> Thanks for testing.
>
> Do you have any comments on performance testing?

Not really, because I didn't have an equivalent environment to compare. These 
tests took exactly the same time as another one with Postgresql 9.3, with a 
major different in the setting of the server:

Postgresql 9.5 RC1
1 GB of RAM
1 vCPU Intel
CentOS 6.5

vs

Postgresql 9.3
8 GB of RAM
4 vCPU LPAR
Redhat 6.5 PowerLinux

So, I can't really compare. So, definitely no performance degradation, and 
possible a performance gain. But of course, this could all be the fault of Alfresco.

Discussing with the Alfresco community I found a benchmarking test which I'm not 
familiar with. I'll make sure to include that test next time I test a 
pre-release version of Postgresql, and I'll make sure to have equivalent 
environment to test.

> Are there any opportunities to improve Alfresco using the new features in
> PostgreSQL 9.5?

I'm not an Alfresco developer, but I'll try to contact the Alfresco engineers to 
discuss this.

> Thanks

You're welcome and I hope next tests will include some performance measurements 
a part from just compliance tests.

Cheers
Boriss

>
> --
> Simon Riggs http://www.2ndQuadrant.com/ <http://www.2ndquadrant.com/>
> PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services