Question about the IO on full table scan operation

From: hsienwen chu <chu(dot)hsien(dot)wen(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Question about the IO on full table scan operation
Date: 2010-10-06 01:19:00
Message-ID: AANLkTi=pYV8MfHt56tPxFFyJBU6=RCRS6ruKidie3es8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Vishnu S. 2010-10-06 03:40:24 Re: [GENERAL] Data Not replicating
Previous Message Lukasz Brodziak 2010-10-05 21:39:36 Re: query execution time