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?
pgsql-admin by date
|Next:||From: Vishnu S.||Date: 2010-10-06 03:40:24|
|Subject: Re: [GENERAL] Data Not replicating|
|Previous:||From: Lukasz Brodziak||Date: 2010-10-05 21:39:36|
|Subject: Re: query execution time|