[GENERAL] 答复: [GENERAL] how to calculate or know seq_scan scan how many blocks every time

Hello Craig: I want to know a sequential scan( full scan table) it can read how many blocks every io? I know scan index read is one block every io. Oracle parameter db_file_multiblock_read_count it can control scattered read (full scan table), assume db_file_multiblock_read_count =10,wh

[GENERAL] 答复: 答复: [GENERAL] how to calculate or know seq_scan scan how many blocks every time

Hello Craig: Thank you very much! -邮件原件- 发件人: Craig Ringer [mailto:ring...@ringerc.id.au] 发送时间: 2012年7月27日 11:00 收件人: leoxu 抄送: pgsql-general@postgresql.org 主题: Re: 答复: [GENERAL] how to calculate or know seq_scan scan how many blocks every time On 07/27/2012 10:04 AM, leoxu wrote