From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Ivan Hernández <ivanx@abulafia.fciencias.unam.mx>
To: Hackers List <pgsql-hackers@postgresql.org>
Cc: pgsql-docs@postgresql.org
Subject: Re: organization file
Date: Thu, 07 Dec 2000 15:59:29 +0000
Message-ID: <3A2FB3E1.373766F8@alumni.caltech.edu> (raw)
References: <lo66kwwu4w.fsf@abulafia.fciencias.unam.mx>
<3A2FABD5.19E279BA@alumni.caltech.edu>
<loofyoyzn9.fsf@abulafia.fciencias.unam.mx>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: lockhart@alumni.caltech.edu, ivanx@abulafia.fciencias.unam.mx, pgsql-hackers@postgresql.org
Subject: Re: organization file
In-Reply-To: <3A2FB3E1.373766F8@alumni.caltech.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox