Re: [HACKERS] Documentation on page files

2002-06-20 Thread Bruce Momjian
Added to CVS. --- Martijn van Oosterhout wrote: On Sun, Apr 21, 2002 at 03:46:07PM +0900, Curt Sampson wrote: On Sat, 20 Apr 2002, Tom Lane wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: 2. If not,

Re: [HACKERS] Documentation on page files

2002-04-23 Thread Martijn van Oosterhout
On Tue, Apr 23, 2002 at 09:15:22AM +0200, Hannu Krosing wrote: On Tue, 2002-04-23 at 01:29, Martijn van Oosterhout wrote: The dumping is more of an extra, the original idea was to check for errors in the datafiles. Hence the working name of pgfsck. At the moment the dumping dumps only

Re: [HACKERS] Documentation on page files

2002-04-23 Thread Curt Sampson
On Tue, 23 Apr 2002, Martijn van Oosterhout wrote: But I think the most useful behaviour should be to dump system fields too, so mildly knowledgeable sysadmin can import the dump and do the right thing afterwards (like restore data as it was before transaction nr 7000) Well, i didn't

Re: [HACKERS] Documentation on page files

2002-04-23 Thread Hannu Krosing
On Tue, 2002-04-23 at 12:52, Martijn van Oosterhout wrote: Well, from my thinking about how you would use these fields in a logical way, it seems it's possible for xmax to be non-zero if the transaction numbered xmax was not committed. But in that case (unless it was a delete) there would be

Re: [HACKERS] Documentation on page files

2002-04-22 Thread Ross J. Reedstrom
On Sun, Apr 21, 2002 at 07:28:32PM +1000, Martijn van Oosterhout wrote: http://svana.org/kleptog/pgsql/page.sgml.txt I don't know whatever SGML format this is using, so the layout is not great, but the information should be accurate. I used it to create a program to dump the datafiles

Re: [HACKERS] Documentation on page files

2002-04-22 Thread Martijn van Oosterhout
On Mon, Apr 22, 2002 at 11:14:36AM -0500, Ross J. Reedstrom wrote: On Sun, Apr 21, 2002 at 07:28:32PM +1000, Martijn van Oosterhout wrote: http://svana.org/kleptog/pgsql/page.sgml.txt I don't know whatever SGML format this is using, so the layout is not great, but the information

Re: [HACKERS] Documentation on page files

2002-04-22 Thread Hannu Krosing
On Tue, 2002-04-23 at 01:29, Martijn van Oosterhout wrote: The dumping is more of an extra, the original idea was to check for errors in the datafiles. Hence the working name of pgfsck. At the moment the dumping dumps only tuples where xmax == 0 but I'm not sure if that's correct. AFAIK it

Re: [HACKERS] Documentation on page files

2002-04-21 Thread Curt Sampson
On Sat, 20 Apr 2002, Tom Lane wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: Chapter 7 of the Developers guide in about the Page Format on disk and it's a little out of date not to mention somewhat incomplete. Indeed, this seems to have very little relation to reality :-(. I

Re: [HACKERS] Documentation on page files

2002-04-21 Thread Martijn van Oosterhout
On Sun, Apr 21, 2002 at 03:46:07PM +0900, Curt Sampson wrote: On Sat, 20 Apr 2002, Tom Lane wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: 2. If not, would patches be accepted to correct the situation? Go for it. Yes, please! I'd be happy to review and updated version.

[HACKERS] Documentation on page files

2002-04-20 Thread Martijn van Oosterhout
[Please CC any replies, I'm subscribed nomail] Hi, Chapter 7 of the Developers guide in about the Page Format on disk and it's a little out of date not to mention somewhat incomplete. 1. Is there documentation elsewhere (other than the source)? 2. If not, would patches be accepted to correct

Re: [HACKERS] Documentation on page files

2002-04-20 Thread Tom Lane
Martijn van Oosterhout [EMAIL PROTECTED] writes: Chapter 7 of the Developers guide in about the Page Format on disk and it's a little out of date not to mention somewhat incomplete. Indeed, this seems to have very little relation to reality :-(. I didn't even realize that we had such a