Thread: organization file

organization file

From
"Ivan Hernández"
Date:
hi, what kind of organization file does postgresql use?

--
/earth is 98% full ... please delete anyone you can.

Re: organization file

From
Thomas Lockhart
Date:
> hi, what kind of organization file does postgresql use?

Hi. I'm not sure what you mean by "file organization". Are you asking
about the file format of tables, or about the directory layout? Both are
discussed in the documentation afaik.

                       - Thomas

Re: organization file

From
"Ivan Hernández"
Date:
Thomas Lockhart <lockhart@alumni.caltech.edu> writes:

> > hi, what kind of organization file does postgresql use?
>
> Hi. I'm not sure what you mean by "file organization". Are you asking
> about the file format of tables, or about the directory layout? Both are
> discussed in the documentation afaik.

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... 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....

ivan ...

>                        - Thomas

--
You are not alone. You are accepted by some non-deterministic automaton

Re: organization file

From
Thomas Lockhart
Date:
> 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