Re: Data transfer very slow when connected via DSL

From: Rainer Bauer <usenet(at)munnin(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Data transfer very slow when connected via DSL
Date: 2007-06-22 10:02:15
Message-ID: 5h7n73hqcac6ksuv23auf691mcmagokalr@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello Dimitri,

>Rainer, but did you try initial query with FETCH_COUNT equal to 100?...

Yes I tried it with different values and it's like you suspected:

FETCH_COUNT 1 Time: 8642,000 ms
FETCH_COUNT 5 Time: 2360,000 ms
FETCH_COUNT 10 Time: 1563,000 ms
FETCH_COUNT 25 Time: 1329,000 ms
FETCH_COUNT 50 Time: 1140,000 ms
FETCH_COUNT 100 Time: 969,000 ms

\unset FETCH_COUNT Time: 390,000 ms

Rainer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Page 2007-06-22 10:12:48 Re: Data transfer very slow when connected via DSL
Previous Message Dimitri 2007-06-22 09:37:40 Re: Data transfer very slow when connected via DSL