PostgreSQL database latency
A remote connection across a Wide Area Network (WAN) between an IVG and the PostgreSQL database is not recommended. If a WAN is used, a latency of 20 ms or greater can lead to a voice platform initialization timeout resulting in an endless loop during IVG startup.
To identify latency between the request and response from the database:
- Open a Linux shell script.
- Log in as the holly user on the remote IVG instance.
- Use the following command to access PostgreSQL:
psql
- Use the following command to verify if the timing is ON or OFF:
\timing
- The response should read Timing is on.
- Use the following command:
select * from CONFIG_VALUES where name='dbrefreshtime' and domain='hlm';
- The response includes a time figure from a local database (ex Time: 2.536 ms)
The Time: value returned should be < 20 ms in order for startup to function reliably.