Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 139749FB4DB for ; Fri, 22 Jun 2007 11:00:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 51574-03-2 for ; Fri, 22 Jun 2007 11:00:17 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from floppy.pyrenet.fr (news.pyrenet.fr [194.116.145.2]) by postgresql.org (Postfix) with ESMTP id 72C379FB4F8 for ; Fri, 22 Jun 2007 11:00:17 -0300 (ADT) Received: by floppy.pyrenet.fr (Postfix, from userid 106) id CDAB431434; Fri, 22 Jun 2007 16:00:15 +0200 (MET DST) From: Rainer Bauer X-Newsgroups: pgsql.performance Subject: Re: Data transfer very slow when connected via DSL Date: Fri, 22 Jun 2007 16:01:49 +0200 Organization: Hub.Org Networking Services Lines: 15 Message-ID: References: <16953.1182439969@sss.pgh.pa.us> <5482c80a0706211432g170154e7x4ee36e5148d272d5@mail.gmail.com> <5482c80a0706211538ka531c18gcf681cd5a68066b2@mail.gmail.com> <9q3n73hcv5ekhl97spfj9bp6erq80j0241@4ax.com> <5482c80a0706220237k23ee1dd8h48160aa73250033e@mail.gmail.com> <5h7n73hqcac6ksuv23auf691mcmagokalr@4ax.com> <5482c80a0706220524x6ebe70d8ga80f30bb20bd97d5@mail.gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: usenet@news.hub.org X-Newsreader: Forte Agent 4.2/32.1117 To: pgsql-performance@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.298 tagged_above=0 required=5 tests=AWL=0.297, BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 200706/538 X-Sequence-Number: 25571 Hello Dimitri, >Hope it's more clear now and at least there is a choice :)) >As well, if your query result will be 500 (for ex.) I think the >difference will be less important between non-CURSOR and "FETCH 500" >execution... The problem is that I am using ODBC and not libpq directly. I will have to rewrite most of the queries and use temporary tables in some places, but at least I know now what the problem was. Thanks for your help. Rainer