pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Joshua D. Drake <jd@commandprompt.com>
To: Rainer Bauer <usenet@munnin.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Data transfer very slow when connected via DSL
Date: Fri, 22 Jun 2007 07:16:18 -0700
Message-ID: <467BD9B2.5010208@commandprompt.com> (raw)
In-Reply-To: <slin731d2jkblh46vovha792eeuhfir2lk@4ax.com>
References: <16953.1182439969@sss.pgh.pa.us>
	<a1el7395bhsv3n867kvefucj90l808hi54@4ax.com>
	<5482c80a0706211432g170154e7x4ee36e5148d272d5@mail.gmail.com>
	<b7tl73pk8u5hptorgnpug6muv0g7bja4q4@4ax.com>
	<5482c80a0706211538ka531c18gcf681cd5a68066b2@mail.gmail.com>
	<9q3n73hcv5ekhl97spfj9bp6erq80j0241@4ax.com>
	<5482c80a0706220237k23ee1dd8h48160aa73250033e@mail.gmail.com>
	<5h7n73hqcac6ksuv23auf691mcmagokalr@4ax.com>
	<5482c80a0706220524x6ebe70d8ga80f30bb20bd97d5@mail.gmail.com>
	<slin731d2jkblh46vovha792eeuhfir2lk@4ax.com>

Rainer Bauer wrote:
> 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.

That opens up some questions. What ODBC driver are you using (with exact 
version please).

Joshua D. Drake

> 
> 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
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match
> 


-- 

       === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/

Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/




view thread (27+ messages)  latest in thread

Message-ID: <467BD9B2.5010208@commandprompt.com>
Permalink:  ../467BD9B2.5010208@commandprompt.com/
Also on:    postgresql.org/message-id/467BD9B2.5010208@commandprompt.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jd@commandprompt.com, usenet@munnin.com
  Subject: Re: Data transfer very slow when connected via DSL
  In-Reply-To: <467BD9B2.5010208@commandprompt.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox