Re: experiments in query optimization

От: Faheem Mitha
Тема: Re: experiments in query optimization
Дата: ,
Msg-id: alpine.DEB.2.00.1004020102060.17251@orwell.homelinux.org
(см: обсуждение, исходный текст)
Ответ на: Re: experiments in query optimization  (Eliot Gable)
Список: pgsql-performance

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

experiments in query optimization  (Faheem Mitha, )
 Re: experiments in query optimization  (Robert Haas, )
  Re: experiments in query optimization  (Faheem Mitha, )
   Re: experiments in query optimization  (Robert Haas, )
    Re: experiments in query optimization  (Faheem Mitha, )
   Re: experiments in query optimization  ("Kevin Grittner", )
    Re: experiments in query optimization  (Faheem Mitha, )
     Re: experiments in query optimization  (Robert Haas, )
      Re: experiments in query optimization  (Faheem Mitha, )
       Re: experiments in query optimization  (Robert Haas, )
       Re: experiments in query optimization  (Faheem Mitha, )
        Re: experiments in query optimization  (Eliot Gable, )
         Re: experiments in query optimization  (Faheem Mitha, )
          Re: experiments in query optimization  (Robert Haas, )
           Re: experiments in query optimization  (Faheem Mitha, )
            Re: experiments in query optimization  (Eliot Gable, )
             Re: experiments in query optimization  (Faheem Mitha, )
     Re: experiments in query optimization  (Matthew Wakeling, )
      Re: experiments in query optimization  (Faheem Mitha, )
    Re: experiments in query optimization  (Faheem Mitha, )


On Thu, 1 Apr 2010, Eliot Gable wrote:

>
>
> On Thu, Apr 1, 2010 at 3:01 PM, Faheem Mitha <> wrote:
>
>                   So, should I add indexes on the individual foreign key cols idlink_id
>                   and anno_id after all?
>
>
>             I doubt that would help.
>
>
> You're sure of this?
>
>
> It is always best to test and be certain.

Fair enough. I may also try disabling hash joins and see what happens...

                                                       Regards, Faheem.


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

От: Scott Carey
Дата:
Сообщение: Re: Database size growing over time and leads to performance impact
От: Christiaan Willemsen
Дата:
Сообщение: Using high speed swap to improve performance?