Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group