how to calculate or know seq_scan scan how many blocks every time

Поиск
Список
Период
Сортировка
От leo xu
Тема how to calculate or know seq_scan scan how many blocks every time
Дата
Msg-id 1343216316780-5717892.post@n5.nabble.com
обсуждение исходный текст
Ответы Re: how to calculate or know seq_scan scan how many blocks every time  (leo xu <leoxu8703@gmail.com>)
Re: how to calculate or know seq_scan scan how many blocks every time  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-general
Дерево обсуждения 
hello:
   i know oracle scatter read blocks,can set db_file_multiblock_read_count
every time,
   i see postgres,it exists scatter read blocks,it is seq_scan,how to know
scan many bloks every time?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/how-to-calculate-or-know-seq-scan-scan-how-many-blocks-every-time-tp5717892.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

Предыдущее
От: Johann Spies
Дата:
Сообщение: Full text search ts_heading strange result
Следующее
От: Andrew Hastie
Дата:
Сообщение: Re: PL/pgSQL - Help or advice please on using unbound cursors