From: | Boriss Mejias <bmejias(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Testing Postgresql 9.5 RC1 with Alfresco 5.0.d |
Date: | 2015-12-28 22:56:50 |
Message-ID: | 5681BE32.5050806@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Geoghegan | 2015-12-28 23:03:25 | Re: Using quicksort for every external sort run |
Previous Message | Fabien COELHO | 2015-12-28 22:29:02 | Re: pgbench stats per script & other stuff |