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 <egable+pgsql-performance@gmail.com>)
Список pgsql-performance

On Thu, 1 Apr 2010, Eliot Gable wrote:

>
>
> On Thu, Apr 1, 2010 at 3:01 PM, Faheem Mitha <faheem@email.unc.edu> 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 по дате отправления:

Предыдущее
От: Eliot Gable
Дата:
Сообщение: Re: experiments in query optimization
Следующее
От: Scott Carey
Дата:
Сообщение: Re: Database size growing over time and leads to performance impact