pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedorganization file
4+ messages / 2 participants
[nested] [flat]
* organization file
@ 2000-12-07 07:46 Ivan Hernández <ivanx@abulafia.fciencias.unam.mx>
0 siblings, 1 reply; 4+ messages in thread
From: Ivan Hernández @ 2000-12-07 07:46 UTC (permalink / raw)
To: pgsql-docs; pgsql-general@postgresql.org
hi, what kind of organization file does postgresql use?
--
/earth is 98% full ... please delete anyone you can.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: organization file
@ 2000-12-07 15:25 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Ivan Hernández <ivanx@abulafia.fciencias.unam.mx>
0 siblings, 1 reply; 4+ messages in thread
From: Thomas Lockhart @ 2000-12-07 15:25 UTC (permalink / raw)
To: Ivan Hernández <ivanx@abulafia.fciencias.unam.mx>; +Cc: pgsql-docs; pgsql-general@postgresql.org
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: organization file
@ 2000-12-07 15:59 Thomas Lockhart <lockhart@alumni.caltech.edu>
parent: Ivan Hernández <ivanx@abulafia.fciencias.unam.mx>
0 siblings, 0 replies; 4+ messages in thread
From: Thomas Lockhart @ 2000-12-07 15:59 UTC (permalink / raw)
To: Ivan Hernández <ivanx@abulafia.fciencias.unam.mx>; Hackers List <pgsql-hackers@postgresql.org>; +Cc: pgsql-docs
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: organization file
@ 2000-12-07 16:17 Ivan Hernández <ivanx@abulafia.fciencias.unam.mx>
parent: Thomas Lockhart <lockhart@alumni.caltech.edu>
0 siblings, 1 reply; 4+ messages in thread
From: Ivan Hernández @ 2000-12-07 16:17 UTC (permalink / raw)
To: Thomas Lockhart <lockhart@alumni.caltech.edu>; +Cc: pgsql-docs
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2000-12-07 16:17 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-12-07 07:46 organization file Ivan Hernández <ivanx@abulafia.fciencias.unam.mx>
2000-12-07 15:25 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
2000-12-07 16:17 ` Ivan Hernández <ivanx@abulafia.fciencias.unam.mx>
2000-12-07 15:59 ` Thomas Lockhart <lockhart@alumni.caltech.edu>
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