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

2009-09-27 Thread Tom Lane
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

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

2009-09-27 Thread Robert Haas
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

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

2009-09-24 Thread Josh Berkus
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'

[PERFORM] Regarding Sequential Scans count increase each time we press refresh .

2009-09-24 Thread keshav upadhyaya
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