Re: experiments in query optimization

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Thu, 1 Apr 2010, Eliot Gable wrote:



On Thu, Apr 1, 2010 at 3:01 PM, Faheem Mitha <faheem@xxxxxxxxxxxxx> 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.

--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux