From: | Clemens Eisserer <linuxhippy(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Slow query execution over high latency network |
Date: | 2011-02-19 10:30:42 |
Message-ID: | AANLkTi=7bOACvdrVOwR8rfgpjU=AjH1oq31H2CCJ8J+1@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Hello,
When executing huge (10kb), hibernate-generated queries I noticed that
when executed remotly over high-latency network (ping to server
200-400ms), the query takes a lot longer to complete.
When the query is executed remotly (psql or jdbc) it takes 1800ms to
execute, when I issue the query in an ssh terminal, I see the results
almost immediatly.
So although I should see the same latency over ssh , its way faster over ssh.
The transmitted data is small (the wireshard-file has 22kb, attached),
and even though the umts-network is high-latency its relativly high
bandwith (~512kbit/s up, ~2mbit/s down).
Any idea whats causing this? Maybe too small buffers somewhere?
For me it poses problem, because I am working on a 2-Tier java
application which should connect to postgres remotly - however with
every more complex query taking 2s its almost unuseable over wireless
networks (umts).
Thank you in advance, Clemens
From | Date | Subject | |
---|---|---|---|
Next Message | Pierre C | 2011-02-19 12:23:18 | Re: Slow query execution over high latency network |
Previous Message | Uwe Bartels | 2011-02-18 15:06:12 | Re: different clients, different query plans |