Skip site navigation (1) Skip section navigation (2)

Re: Regarding Sequential Scans count increase each time we press refresh .

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: keshav upadhyaya <ukeshav2009(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Regarding Sequential Scans count increase each time we press refresh .
Date: 2009-09-27 18:38:06
Message-ID: 603c8f070909271138p75905dfat68c1d6f4852a2284@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
On Thu, Sep 24, 2009 at 8:25 PM, Josh Berkus <josh(at)agliodbs(dot)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

In response to

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2009-09-27 19:17:13
Subject: Re: Regarding Sequential Scans count increase each time we press refresh .
Previous:From: Sergey SamokhinDate: 2009-09-27 17:55:48
Subject: Re: GRANT SELECT on all the partitions?

pgsql-performance by date

Next:From: Robert HaasDate: 2009-09-27 18:40:04
Subject: Re: query memory consumption
Previous:From: Gerhard WiesingerDate: 2009-09-27 07:09:26
Subject: Re: Many left outer joins with limit performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group