Regarding Sequential Scans count increase each time we press refresh .

Поиск
Список
Период
Сортировка
От keshav upadhyaya
Тема Regarding Sequential Scans count increase each time we press refresh .
Дата
Msg-id d40c44910909241032k28fde9eet83d872d9a93f981a@mail.gmail.com
обсуждение исходный текст
Ответы Re: Regarding Sequential Scans count increase each time we press refresh .  (Josh Berkus <josh@agliodbs.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Dave Dutcher"
Дата:
Сообщение: Re: High CPU load on Postgres Server during Peak times!!!!
Следующее
От: Karl Denninger
Дата:
Сообщение: Re: High CPU load on Postgres Server during Peak times!!!!