Unix Technical Forum

How are tables stored fisically in HD?

This is a discussion on How are tables stored fisically in HD? within the pgsql Hackers forums, part of the PostgreSQL category; --> Hi, my teacher want's me to find out and explain how PgSQL stores data fisically! I've done searches but ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-12-2008, 01:46 AM
Bruno Cassol
 
Posts: n/a
Default How are tables stored fisically in HD?

Hi, my teacher want's me to find out and explain how PgSQL stores data
fisically! I've done searches but could not find it. Please help me!





__________________________________________________ _____
Yahoo! doce lar. Faça do Yahoo! sua homepage.
http://br.yahoo.com/homepageset.html


---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-12-2008, 01:46 AM
Larry Rosenman
 
Posts: n/a
Default Re: How are tables stored fisically in HD?

Bruno Cassol wrote:
> Hi, my teacher want's me to find out and explain how PgSQL stores
> data fisically! I've done searches but could not find it. Please help
> me!
>

Read the docs. It's all in there.

LER

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 512-248-2683 E-Mail: ler@lerctr.org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3683 US


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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-12-2008, 01:46 AM
Josh Berkus
 
Posts: n/a
Default Re: How are tables stored fisically in HD?

Bruno,

> Read the docs. It's all in there.


More specifically:
http://www.postgresql.org/docs/8.1/i...internals.html

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 04-12-2008, 01:46 AM
Jim C. Nasby
 
Posts: n/a
Default Re: How are tables stored fisically in HD?

On Tue, Mar 28, 2006 at 08:40:27AM -0300, Bruno Cassol wrote:
> Hi, my teacher want's me to find out and explain how PgSQL stores data
> fisically! I've done searches but could not find it. Please help me!


http://www.postgresql.org/docs/8.1/i...e/storage.html
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:33 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com