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

Re: organization file

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: Ivan Hernández <ivanx(at)abulafia(dot)fciencias(dot)unam(dot)mx>, Hackers List <pgsql-hackers(at)postgresql(dot)org>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: organization file
Date: 2000-12-07 15:59:29
Message-ID: 3A2FB3E1.373766F8@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-docspgsql-generalpgsql-hackers
> hi, yes a was talking about the first: the file format of tables. I was
> reading about diferent file organizations (structures): sequential, heal,
> ring, multi ring, etc...

afaik most of the files are sequential in nature, with some record
updates happening in the middle to mark records as "obsolete". So data
is added on to the end, which is why running VACUUM is so important.

> I look for some info in the documentation but i
> didn't find nothing, also i'm interested about the recovery system of
> postgresql.... i hope that you can give me some hints about where i can
> look for it....

In previous releases, since all files are written sequentially the
recovery system is very simple. For the upcoming 7.1 release with WAL,
there is likely more done, but I'm not familiar with the details.

Somebody want to write a (short) description? I'll include it in the
docs...

                     - Thomas

In response to

pgsql-docs by date

Next:From: Ivan =?iso-8859-1?q?Hern=E1ndez?=Date: 2000-12-07 16:17:14
Subject: Re: organization file
Previous:From: Thomas LockhartDate: 2000-12-07 15:25:09
Subject: Re: organization file

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2000-12-07 16:15:07
Subject: Re: RFC C++ Interface
Previous:From: Thomas LockhartDate: 2000-12-07 15:25:09
Subject: Re: organization file

pgsql-general by date

Next:From: Ivan =?iso-8859-1?q?Hern=E1ndez?=Date: 2000-12-07 16:17:14
Subject: Re: organization file
Previous:From: Thomas LockhartDate: 2000-12-07 15:25:09
Subject: Re: organization file

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