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

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

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

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 du

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

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 infor

Re: [HACKERS] Documentation on page files

2002-04-22 Thread Patrick Macdonald
Martijn, It may be useful to look at the pg_filedump utility located at http://sources.redhat.com/rhdb/tools.html This utility dumps out information at the page level and is commented to help the user understand the format/content of PostgreSQL heap/index/control files. Cheers, Patrick ---

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 datafile

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 update

Re: [HACKERS] Documentation on page files

2002-04-20 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 :-(

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 desc

[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 t