Postgres DB optimization

[Guillaume]

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

[Modesto Vega]

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

[Guillaume]

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

[Geert Bellekens]

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