Postgres Pro
Downloads
Home   >   mailing lists

Question about the IO on full table scan operation - Mailing list pgsql-admin

From hsienwen chu
Subject Question about the IO on full table scan operation
Date
Msg-id AANLkTi=pYV8MfHt56tPxFFyJBU6=RCRS6ruKidie3es8@mail.gmail.com
Whole thread Raw
Responses Re: Question about the IO on full table scan operation
List pgsql-admin
Tree view

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


pgsql-admin by date:

Previous
From: Lukasz Brodziak
Date:
Subject: Re: query execution time
Next
From: Greg Smith
Date:
Subject: Re: vacuum full table - internals in 8.3