The multitude of postgresql, system, proxy, etc. caches. at all levels seems to prevent de facto obtaining reliable measurements during performance tests, including for the evaluation of the short-term etag cache.
This is the reason why a bench test would require, for example, a scope of several thousand or even hundreds of thousands of features and with a minimum volume of data.
A first qualification environment within the GeoPlatform infrastructure is therefore necessary, knowing that it will evolve according to future needs:
etag cache tests
load tests with one or more nodes for the pg_featureserv service
load, tuning and fault tolerance testing with at least two postgres nodes/instances or even more
load tests with many features of limited size, large features, with a large number of concurrent requests, etc.
...
In terms of machines, I guess we could already start with the idea of one VM for one postgres instance and two VMs for two pg_featureserv instances. This while bearing in mind that the needs will be greater later, the time to develop the service in the platform?
Note: we are not yet talking about load tests requiring several guest VMs.
In GitLab by @nrevelant on Oct 24, 2022, 16:14
The multitude of postgresql, system, proxy, etc. caches. at all levels seems to prevent de facto obtaining reliable measurements during performance tests, including for the evaluation of the short-term etag cache.
This is the reason why a bench test would require, for example, a scope of several thousand or even hundreds of thousands of features and with a minimum volume of data.
A first qualification environment within the GeoPlatform infrastructure is therefore necessary, knowing that it will evolve according to future needs:
In terms of machines, I guess we could already start with the idea of one VM for one postgres instance and two VMs for two pg_featureserv instances. This while bearing in mind that the needs will be greater later, the time to develop the service in the platform?
Note: we are not yet talking about load tests requiring several guest VMs.