| 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: | Whole Thread | Raw Message | 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 |