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
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
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
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
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-