Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: Guillaume on November 08, 2019, 11:12:58 pm

Title: Postgres DB optimization
Post by: Guillaume on November 08, 2019, 11:12:58 pm

Hi,

We have a large Postgres DB running the EA repository (2GB dump file). Accessed via the Cloud Service, I find it a bit slow sometimes.
I ran the integrity check. Is there any optimization I can look at on the DB itself?

Thanks

Title: Re: Postgres DB optimization
Post by: Modesto Vega on November 08, 2019, 11:21:48 pm

Do you mean the Sparx EA cloud service or some other cloud service such as AWS or Azure?

Title: Re: Postgres DB optimization
Post by: Guillaume on November 08, 2019, 11:38:37 pm

I mean Sparx Cloud Service so users don't have to set up ODBC (they have a url).

Title: Re: Postgres DB optimization
Post by: Geert Bellekens on November 09, 2019, 06:58:47 pm

You could try to have a DBA investigate and tweak some indexes, but realistically this won't really help.

I have found that the only way to really solve this type of performance issues is to use Remote Desktop or Citrix (and make sure the RD or Citrix server is in the same datacenter as the database)
This has an added advantage that you don't need to install EA on all of the client machines, but only on the server(s)

Geert