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

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: how to calculate or know seq_scan scan how many blocks every time
Дата
Msg-id 5011E38B.6000207@ringerc.id.au
обсуждение исходный текст
Ответ на how to calculate or know seq_scan scan how many blocks every time  (leo xu <leoxu8703@gmail.com>)
Ответы 答复: [GENERAL] how to calculate or know seq_scan scan how many blocks every time  ("leoxu" <leoxu8703@gmail.com>)
Список pgsql-general
On 07/25/2012 07:38 PM, leo xu wrote:
> 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?
>

If I understand correctly, you want to have a sequential scan read from
more than one place at once.

This is not currently supported.

The effective_io_concurrency setting would be where you would set it,
but it does not affect sequential scans at the moment.

--
Craig Ringer

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: FATAL : could not read directory base": Invalid argument
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Replication/cloning: rsync vs modification dates?