Testing Postgresql 9.5 RC1 with Alfresco 5.0.d - Mailing list pgsql-hackers

From Boriss Mejias
Subject Testing Postgresql 9.5 RC1 with Alfresco 5.0.d
Date
Msg-id 5681BE32.5050806@dcc.uchile.cl
Whole thread Raw
Responses Re: Testing Postgresql 9.5 RC1 with Alfresco 5.0.d
List 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    -
Alfrescorunning on a different VM.
 

Test Procedure:    - Vanilla installation of Alfresco Community Edition 5.0.d    - Using the default jdbc driver
shippedwith Alfresco    - Test that Alfresco Shares works correctly with the basic functionality    - Script with
multipleHTTP 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,
Iwasn'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-releaseversion of 
 
Postgresql, so any comment of ideas are welcome to contribute again next time.

Cheers
Boriss



pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: pgbench stats per script & other stuff
Next
From: Peter Geoghegan
Date:
Subject: Re: Using quicksort for every external sort run