Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group