От: Dave Page
Тема: Re: speed of querry?
Дата: ,
Msg-id: E7F85A1B5FF8D44C8A1AF6885BC9A0E472C2AD@ratbert.vale-housing.co.uk
(см: обсуждение, исходный текст)
Ответ на: speed of querry?  ("Joel Fradkin")
Ответы: Re: speed of querry?  ("Joel Fradkin")
Список: pgsql-performance

Скрыть дерево обсуждения

speed of querry?  ("Joel Fradkin", )
 Re: speed of querry?  (Richard Huxton, )
  Re: speed of querry?  ("Joel Fradkin", )
  Re: speed of querry?  (Tom Lane, )
   Re: speed of querry?  ("Joel Fradkin", )
    Re: speed of querry?  (Dawid Kuroczko, )
     Re: speed of querry?  ("Joel Fradkin", )
      Re: speed of querry?  (Dawid Kuroczko, )
       Re: speed of querry?  (Tom Lane, )
        Re: speed of querry?  ("Joel Fradkin", )
         Re: speed of querry?  ("Joel Fradkin", )
 Re: speed of querry?  ("Dave Held", )
  Re: speed of querry?  ("Joel Fradkin", )
   Re: speed of querry?  (Tom Lane, )
    Re: speed of querry?  ("Joel Fradkin", )
     Re: speed of querry?  (Tom Lane, )
 Re: speed of querry?  ("Dave Page", )
  Re: speed of querry?  ("Joel Fradkin", )


> -----Original Message-----
> From: 
> [mailto:] 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


В списке pgsql-performance по дате сообщения:

От: Jacques Caron
Дата:
Сообщение: Re: How to improve db performance with $7K?
От: Bill Chandler
Дата:
Сообщение: Question on REINDEX