> 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'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.
PostgreSQL Experts Inc.
In response to
pgsql-novice by date
|Next:||From: Tim Bowden||Date: 2009-09-25 03:05:01|
|Subject: Re: what comes after apt-get for a Debian installation?|
|Previous:||From: Wm.A.Stafford||Date: 2009-09-24 19:39:03|
|Subject: what comes after apt-get for a Debian installation?|
pgsql-performance by date
|Next:||From: Dan Sugalski||Date: 2009-09-25 03:21:55|
|Subject: PG 8.3 and large shared buffer settings|
|Previous:||From: Craig James||Date: 2009-09-24 18:45:28|
|Subject: Re: High CPU load on Postgres Server during Peak times!!!!|