Question about the IO on full table scan operation

Поиск
Список
Период
Сортировка
От hsienwen chu
Тема Question about the IO on full table scan operation
Дата
Msg-id AANLkTi=pYV8MfHt56tPxFFyJBU6=RCRS6ruKidie3es8@mail.gmail.com
обсуждение исходный текст
Ответы Re: Question about the IO on full table scan operation  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-admin

Dear all

the situation is that: I have a table, and the size is about 10M, I run the database on Redhat Linux platform. for OS, a IO can hand 1M data, the file system block is 4k, database block is 8k,

my question is that: when do the full table scan on the table, how many IO will be done? 10M/1M=10 ? or 10M/8k=1280? or 10M/4k=2560?

I'm confuse for this, does any could help me?


Many Thanks
Tony


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

Предыдущее
От: Lukasz Brodziak
Дата:
Сообщение: Re: query execution time
Следующее
От: Greg Smith
Дата:
Сообщение: Re: vacuum full table - internals in 8.3