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.