Hi,
i want to know how postgres will store a
relation in pages and where can i see the code related
to this in the source code.Plz help me .

S.Nithin




__________________________________
Discover Yahoo!
Use Yahoo! to plan a weekend, have fun online and more. Check it out!
http://discover.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Nithin Sontineni wrote:
> Hi,
> i want to know how postgres will store a
> relation in pages and where can i see the code related
> to this in the source code.Plz help me .
>
> S.Nithin
>
>
>
>
> __________________________________
> Discover Yahoo!
> Use Yahoo! to plan a weekend, have fun online and more. Check it out!
> http://discover.yahoo.com/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings


Nithin,

You can find the code in src/backend/storage.
There you will find a couple of directories containing code of various
parts of the storage system.

I guess you will be most interested in page/bufpage.c. There you can see
how a page works. I highly suggest to read the corresponding header file

[hs@athlon storage]$ pwd
/usr/src/pg/postgresql-8.0.2/src/include/storage
[hs@athlon storage]$ ls -l bufpage.h
-rw-r--r-- 1 hs hs 10255 Dec 31 23:03 bufpage.h

There you can find information about the layout of pages.

best regards,

hans


--
Cybertec Geschwinde u Schoenig
Schoengrabern 134, A-2020 Hollabrunn, Austria
Tel: +43/664/393 39 74
www.cybertec.at, www.postgresql.at


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <postgres@cybertec.at> writes:
> Nithin Sontineni wrote:
>> i want to know how postgres will store a
>> relation in pages and where can i see the code related
>> to this in the source code.Plz help me .

> You can find the code in src/backend/storage.

Also, read the docs first:
http://developer.postgresql.org/docs...s/storage.html
That's pretty high-level but I think you need the context before
you start reading code ...

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org