Degraded PostgreSQL query performance (psql) on only one machine

Hi there, we are using fly.io for 2+ years and really love it.

What we were debugging today yet did not make any sense though!

on one machine issuing a SQL query against a remote PostgreSQL running on Hetzner connected via fly wireguard VPN was very slow (17 seconds instead of expected 1 second)

we then scaled to 2nd machine (same region =cdg). same query on 2nd machine was fast (1 second)

did this on both machines:

  • we checked network performance with iperf → same results on both machines
  • we checked cpu and ram speed with sysbench → same results on both machines

both machines are still up in case you want to have a look!

appreciate any help or explanations

Steve

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.