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

Re: regarding storage in postgres

From: Hans-Jürgen Schönig <postgres(at)cybertec(dot)at>
To: Nithin Sontineni <nithin_iiit(at)yahoo(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: regarding storage in postgres
Date: 2005-06-01 08:35:06
Message-ID: 429D733A.2040805@cybertec.at (view raw or flat)
Thread:
Lists: pgsql-hackers
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(at)athlon storage]$ pwd
/usr/src/pg/postgresql-8.0.2/src/include/storage
[hs(at)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


In response to

Responses

pgsql-hackers by date

Next:From: Greg StarkDate: 2005-06-01 08:44:24
Subject: Re: NOLOGGING option, or ?
Previous:From: Christopher Kings-LynneDate: 2005-06-01 08:34:38
Subject: Re: NOLOGGING option, or ?

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