> -----Original Message-----
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Joel Fradkin
> Sent: 18 April 2005 14:02
> To: PostgreSQL Perform
> Subject: FW: [PERFORM] speed of querry?
> Another odd thing is when I tried turning off merge joins on 
> the XP desktop
> It took 32 secs to run compared to the 6 secs it was taking.
> On the Linux (4proc box) it is now running in 3 secs with the 
> mergejoins
> turned off.
> Unfortunately it takes over 2 minutes to actually return the 
> 160,000+ rows.
> I am guessing that is either network (I have gig cards on a 
> LAN) or perhaps
> the ODBC driver (using PGADMIN III to do the select).

pgAdmin III uses libpq, not the ODBC driver.

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to