[midPoint] PostgreSQL indexes

[Pavol Mederly]

Hello Gustavo,

thank you for the contribution.

I would suggest to modify files in 
/midpoint/config/sql/midpoint/3.6/postgresql/ directory.

Before 3.6 release, we will update files in the "_all" directory 
accordingly. (We do it by hand.)

The files in 3.5 directory need not be updated. Unless you would like to 
make this improvement a part of support-3.5 branch. In that case you 
could update _all/postgresql and midpoint/3.5/postgresql/ files as well 
(and cherry-pick appropriate changes to support-3.5 branch).

Best regards,

Pavol Mederly
Software developer
evolveum.com

On 26.04.2017 18:08, Gustavo J Gallardo wrote:
> Hi all,
> we have a number of indexes to add to the SQL files, mainly indexes 
> for foreign keys (unlike Oracle and other databases, PostgreSQL does 
> not create an index automatically when a foreign key is defined).
>
> In which file(s) should I commit (and then pull request) these changes:
>
> /midpoint/config/sql/_all/postgresql-3.5-all.sql
> /midpoint/config/sql/_all/postgresql-upgrade-3.4-3.5-all.sql
>
> /midpoint/config/sql/midpoint/3.5/postgresql/postgresql-3.5-all.sql
> /midpoint/config/sql/midpoint/3.5/postgresql/postgresql-upgrade-3.4-3.5-all.sql
>
> /midpoint/config/sql/midpoint/3.6/postgresql/postgresql-3.6-all.sql
> /midpoint/config/sql/midpoint/3.6/postgresql/postgresql-upgrade-3.5-3.6-all.sql
>
> Is there any type of automatic process to e.g. merge the 
> .../midpoint/... files into .../_all/... files?
>
>
> Thanks,
>
> GJG
>
>
> _______________________________________________
> midPoint mailing list
> midPoint at lists.evolveum.com
> http://lists.evolveum.com/mailman/listinfo/midpoint

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.evolveum.com/pipermail/midpoint/attachments/20170426/b14c1976/attachment.htm>