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

Regarding Sequential Scans count increase each time we press refresh .

From: keshav upadhyaya <ukeshav2009(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Regarding Sequential Scans count increase each time we press refresh .
Date: 2009-09-24 17:41:15
Message-ID: d40c44910909241041t35d3edb5p4730453bcea41e0d@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-performance
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 happening ?  Is it scanning the
Table sequentially once i press refresh  ?

Thanks,
keshav




-- 
Thanks,
Keshav Upadhyaya

In response to

Responses

pgsql-novice by date

Next:From: Wm.A.StaffordDate: 2009-09-24 19:39:03
Subject: what comes after apt-get for a Debian installation?
Previous:From: keshav upadhyayaDate: 2009-09-24 17:32:54
Subject: Regarding Sequential Scans count increase each time we press refresh .

pgsql-performance by date

Next:From: Karl DenningerDate: 2009-09-24 17:55:50
Subject: Re: High CPU load on Postgres Server during Peak times!!!!
Previous:From: keshav upadhyayaDate: 2009-09-24 17:32:54
Subject: Regarding Sequential Scans count increase each time we press refresh .

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