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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-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

Browse pgsql-novice by date

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

Browse pgsql-performance by date

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