disk pages, buffers and blocks

From: Alice Lottini <alice_lottini(at)yahoo(dot)it>
To: PostgreSQL Mailing List Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: disk pages, buffers and blocks
Date: 2003-02-06 16:30:01
Message-ID: 20030206163001.400.qmail@web13708.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
we'd like to know how disk pages map to disk blocks.
In particular, looking at the code it seems that one
page can be built on several disk blocks while in the
first lines of bufpage.h it is said that "a postgres
disk page is an abstraction layered on top of *a*
postgres disk block".
As a matter of fact, it looks quite reasonable to have
more than a block per page.
We've also found out that a postgres buffer contains
exactly one disk block, but we'd like to understand
how pages, blocks and buffers relate to each other.

Thank you very much for your help!
regards, alice and lorena

______________________________________________________________________
Yahoo! Cellulari: loghi, suonerie, picture message per il tuo telefonino
http://it.yahoo.com/mail_it/foot/?http://it.mobile.yahoo.com/index2002.html

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-02-06 17:24:39 Re: disk pages, buffers and blocks
Previous Message Andrew Sullivan 2003-02-06 16:15:30 Re: databases limit