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

2012-08-01 Thread leoxu
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

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

2012-07-26 Thread Craig Ringer
On 07/27/2012 10:04 AM, leoxu wrote: > 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 sca

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

2012-07-26 Thread leoxu
27日 8:41 收件人: leo xu 抄送: pgsql-general@postgresql.org 主题: Re: [GENERAL] how to calculate or know seq_scan scan how many blocks every time 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

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

2012-07-26 Thread Craig Ringer
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

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

2012-07-25 Thread leo xu
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-