High, inconsistent query latency in warm node from same region
I'm testing a project on Neon cloud (
tiny-sky-56601552
tiny-sky-56601552
) in eu-central-1 and connecting from the same region, but get 40-60ms latency for simple queries.
The latency should be single digit milliseconds as my queries are simple:
insert into .. returning id
insert into .. returning id
or
update .. where returning id, revision
update .. where returning id, revision
, etc.
But I'm observing most queries take around 40-60ms to complete, with a few lucky ones randomly much faster at ~5ms (as it should be). This kills performance when executing even just a couple queries per request. Any ideas?