...
A customer reported longer than expected fetch times and frequent Postgres timeouts. With a server configuration of 256 GB RAM and 32 CPU cores, the daily fetch rate was expected to be well above 100,000, 100K documents but was less than 70.00070K. This led us to change the Postgres memory usage configuration as described below.
...
The configuration changes produced a positive change in server performance. The daily document fetch rate went increased to above 100,000 and there were no more Postgres timeouts being reported. The values used are based on the recommended values while at the same time also taking into consideration that Postgres was not running on a dedicated server.
...