| From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
|---|---|
| To: | "Joel Fradkin" <jfradkin(at)wazagua(dot)com>, "PostgreSQL Perform" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: speed of querry? |
| Date: | 2005-04-18 13:18:57 |
| Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E472C2AD@ratbert.vale-housing.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-owner(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joel Fradkin | 2005-04-18 13:31:57 | Re: speed of querry? |
| Previous Message | Joel Fradkin | 2005-04-18 13:09:21 | FW: speed of querry? |