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

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

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: keshav upadhyaya <ukeshav2009(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Regarding Sequential Scans count increase each time we press refresh .
Date: 2009-09-25 00:25:06
Message-ID: 4ABC0DE2.5040202@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
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'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.

-- 
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com

In response to

Responses

pgsql-novice by date

Next:From: Tim BowdenDate: 2009-09-25 03:05:01
Subject: Re: what comes after apt-get for a Debian installation?
Previous:From: Wm.A.StaffordDate: 2009-09-24 19:39:03
Subject: what comes after apt-get for a Debian installation?

pgsql-performance by date

Next:From: Dan SugalskiDate: 2009-09-25 03:21:55
Subject: PG 8.3 and large shared buffer settings
Previous:From: Craig JamesDate: 2009-09-24 18:45:28
Subject: Re: High CPU load on Postgres Server during Peak times!!!!

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