Grouper Users - Open Discussion List

[Robert Bradley <>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

On 10/03/18 07:28, Tornóci László wrote:
> On 03/09/2018 07:28 PM, Jack Stewart wrote:
>> Everyone,
>> 
>> I would like to ask you as to your preferences for the Grouper 
>> database.  Do you prefer MySQL or Oracle?  Why do you prefer one
>> over the other, and why do you NOT prefer the other?
> 
> What about Postgresql? Any experience with that?
> 

My experience is that the Grouper/Postgres combination works well, but
that using Postgres 9.1 and earlier with Grouper can result in slow
performance due to the query planner.  If you stick to
currently-supported versions of Postgres (>=9.4) though, you should
have few problems.  You may need to add extra indexes occasionally,
but your Postgres DBAs should be able to help with that.

- -- 
Dr Robert Bradley
Identity and Access Management Team, IT Services, University of Oxford
-----BEGIN PGP SIGNATURE-----

iQIzBAEBCAAdFiEEgF3NFfO9FqlA+ME+lGGnynav474FAlqoCrIACgkQlGGnynav
476+JQ/+LWOmZZ556EjSKlXHjSkmxpebM89Nw1JbEZ+vt5V1Km3tJChawR8pmrwT
CVmyq96gIQmPE70V+I34EIjLJke1FKG9sydm1//iCMt5vZCNof/8RycEIRytFVLa
YFyjI2r+aL0hqIrAs0r9iJ3IN+KmynChpTQRoFQOzTAFSb7/yq33wLpvmSY8s1SH
d0yhTaLgdkWYnlVUSFnx0bzeR7/AsaXQHjfzdX1C4FQzHMtMNOm1CR/RR+fW3EX2
aPfNJMJt1cS3pxRpROY4XEU/ZQC1V70WJRWEVP6WBKbjW3ocbHKWLwF9bVK7XUe8
Cg9XSohk59hMvaWzsb7jWdfJybwy3wQCRutRLYcOdQ+YJzlBbObF2AprhXD9nWJi
VfTUlYMJXhD7yvCnau/hv3ujwCAP9AqF/kEfUyXO3WL8ixqv1MuP004li+q86at4
hMjzsb1YvgnNuUP5VxVxnJuAyh79S8xVQsCsV8SdrV1xB+EYXK9P0kXpByvydUHD
p1x2kwnceC2WF6DEC0VPkDqM6IYxZKslh9AmbyU1Asw/ekmZAzL3ZuPnmUurraSd
vl5A4AdiqhBlbeDXGuWy/16U09hJb/XOjiKD6uJ9W8bIzN9F+3Qz0CoctQntIE96
Bq8zHIRpPxAUs4WdvAXZr5ba4FnqqbVGyK8CKmjp/ADV5PMTKBw=
=3QHm
-----END PGP SIGNATURE-----