Re: Regarding Sequential Scans count increase each time we press refresh . - Mailing list pgsql-performance

From Robert Haas
Subject Re: Regarding Sequential Scans count increase each time we press refresh .
Date
Msg-id 603c8f070909271138p75905dfat68c1d6f4852a2284@mail.gmail.com
Whole thread Raw
In response to Re: Regarding Sequential Scans count increase each time we press refresh .  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Regarding Sequential Scans count increase each time we press refresh .  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On Thu, Sep 24, 2009 at 8:25 PM, Josh Berkus <josh@agliodbs.com> wrote:
> You can't "turn off" sequential scans.  You can only make the planner
> less likely to choose them.  But if there's no way to get the data you
> need other than a seqscan, it's still going to do one.

And that's not a bad thing.  For a very small table, it's often the
fastest method.

...Robert

pgsql-performance by date:

Previous
From: Gerhard Wiesinger
Date:
Subject: Re: Many left outer joins with limit performance
Next
From: Robert Haas
Date:
Subject: Re: query memory consumption