Re: experiments in query optimization

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

To: Faheem Mitha <faheem@xxxxxxxxxxxxx>
Subject: Re: experiments in query optimization
From: Eliot Gable <egable+pgsql-performance@xxxxxxxxx>
Date: Thu, 1 Apr 2010 15:29:17 -0400
Cc: Robert Haas <robertmhaas@xxxxxxxxx>, Kevin Grittner <Kevin.Grittner@xxxxxxxxxxxx>, pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <alpine.DEB.2.00.1004020028220.17251@xxxxxxxxxxxxxxxxxxxx>
References: <alpine.DEB.2.00.1003251457350.13883@xxxxxxxxxxxxxxxxxxxx> <4BB1DB9A020000250003020E@xxxxxxxxxxxxxxx> <alpine.DEB.2.00.1003302151030.13883@xxxxxxxxxxxxxxxxxxxx> <603c8f071003301259u140d8556vc54ff46855013bd3@xxxxxxxxxxxxxx> <alpine.DEB.2.00.1003311506300.13883@xxxxxxxxxxxxxxxxxxxx> <alpine.DEB.2.00.1004011708460.26028@xxxxxxxxxxxxxxxxxxxx> <p2mbf6923ed1004010931y43e9fe45mb5be9117b53cbb36@xxxxxxxxxxxxxx> <alpine.DEB.2.00.1004012230520.17251@xxxxxxxxxxxxxxxxxxxx> <w2q603c8f071004011150h4bf8c5bs2b00041b51b0bb49@xxxxxxxxxxxxxx> <alpine.DEB.2.00.1004020028220.17251@xxxxxxxxxxxxxxxxxxxx>

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.

Follow-Ups:
- Re: experiments in query optimization
  - From: Faheem Mitha

References:
- experiments in query optimization
  - From: Faheem Mitha
- Re: experiments in query optimization
  - From: Kevin Grittner
- Re: experiments in query optimization
  - From: Faheem Mitha
- Re: experiments in query optimization
  - From: Robert Haas
- Re: experiments in query optimization
  - From: Faheem Mitha
- Re: experiments in query optimization
  - From: Faheem Mitha
- Re: experiments in query optimization
  - From: Eliot Gable
- Re: experiments in query optimization
  - From: Faheem Mitha
- Re: experiments in query optimization
  - From: Robert Haas
- Re: experiments in query optimization
  - From: Faheem Mitha

Prev by Date: Re: experiments in query optimization
Next by Date: Re: experiments in query optimization
Previous by thread: Re: experiments in query optimization
Next by thread: Re: experiments in query optimization
Index(es):
- Date
- Thread

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

Powered by Linux