Robert Haas writes:
> On Thu, Sep 24, 2009 at 8:25 PM, Josh Berkus 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
On Thu, Sep 24, 2009 at 8:25 PM, Josh Berkus 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 sma
Keshav,
> I have one table my_test table . with on index created on one column .
>
>
> I have turned off the sequential scans .
>
> Now when ever i do refresh on this table or press F5 , It increase the
> sequential scans count and
> Sequential tuple read count .
What's a "refresh"?
You can'
Hi ,
I have one table my_test table . with on index created on one column .
I have turned off the sequential scans .
Now when ever i do refresh on this table or press F5 , It increase the
sequential scans count and
Sequential tuple read count .
Pls help me to understand what exactly is happen