> -----Original Message-----
> From: pgsql-performance-owner@postgresql.org
> [mailto:pgsql-performance-owner@postgresql.org] 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