Testing Postgresql 9.5 RC1 with Alfresco 5.0.d
Hi there,
The following wiki page:
https://wiki.postgresql.org/wiki/HowToBetaTest#How_to_Test
suggests that I should send the following report to this mailing list.
Name: Boriss Mejías (Tchorix)
Release: Postgresql 9.5 RC1
Test Type: Compatibility with Alfresco Community Edition 5.0.d
Test Detail: New Alfresco installation with Postgresql 9.5 RC1. Testing updates
into the database.
Platform: CentOS 6.5
Installation Method: Compiled from tarball. Default parameters.
Platform Detail:
- VMWare virtual machine
- RAM: 1GB
- CPU: Intel(R) Xeon(R) CPU E5-2660 0 @ 2.20GHz
- Alfresco running on a different VM.
Test Procedure:
- Vanilla installation of Alfresco Community Edition 5.0.d
- Using the default jdbc driver shipped with Alfresco
- Test that Alfresco Shares works correctly with the basic functionality
- Script with multiple HTTP REST calls to create/read/delete users. Each
operation/transaction involves several tables.
Failure? No
Test Results:
- Alfresco worked as expected.
- Scripts are run in parallel to expect race conditions. Alfresco uses
optimistic approach.
- Constraint violations on table-keys are observed in the logs, which is
good, because data remains consistent, and Alfresco handles the error messages
correctly.
Comments:
- I just wrote my own scripts to test the consistency of users data. I'm
not part of Alfresco Inc to use their official test bed
- Alfresco uses Ibatis to control de database model. Hence, I wasn't
expecting any failure.
- I don't have control of the table indexes, and I was not able to compare
the test with a previous version of Postgresql to test performance.
- This is the first time I run a test of a previous-release version of
Postgresql, so any comment of ideas are welcome to contribute again next time.
Cheers
Boriss
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On 28 December 2015 at 22:56, Boriss Mejias <bmejias@dcc.uchile.cl> wrote:
Hi there,
The following wiki page:
https://wiki.postgresql.org/wiki/HowToBetaTest#How_to_Test
suggests that I should send the following report to this mailing list.
Thanks for testing.
Do you have any comments on performance testing?
Are there any opportunities to improve Alfresco using the new features in
PostgreSQL 9.5?
Thanks
--
Simon Riggs http://www.2ndQuadrant.com/
<http://www.2ndquadrant.com/>
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers