Re: [HACKERS] WAL documentation changes

2008-12-18 Thread Bruce Momjian
Tatsuo Ishii wrote: Bruce, In your document change which one can be placed on non-journalling file system? data? wal? or both? Both. I have updated the docs to mention this, patch attached. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB

Re: [HACKERS] WAL documentation changes

2008-12-18 Thread Kevin Grittner
Bruce Momjian br...@momjian.us wrote: Tatsuo Ishii wrote: In your document change which one can be placed on non-journalling file system? data? wal? or both? Both. I have updated the docs to mention this, patch attached. Did you mean to say that journaled file systems are *not*

Re: [HACKERS] WAL documentation changes

2008-12-18 Thread Bruce Momjian
Kevin Grittner wrote: Bruce Momjian br...@momjian.us wrote: Tatsuo Ishii wrote: In your document change which one can be placed on non-journalling file system? data? wal? or both? Both. I have updated the docs to mention this, patch attached. Did you mean to say that journaled

Re: [HACKERS] WAL documentation changes

2008-12-18 Thread Kevin Grittner
Bruce Momjian br...@momjian.us wrote: Kevin Grittner wrote: Did you mean to say that journaled file systems are *not* necessary? Yes, not needed for database reliablity. The patch text was attached; was it unclear? I think you accidentally left out the word not. -Kevin -- Sent via

Re: [HACKERS] WAL documentation changes

2008-12-18 Thread Bruce Momjian
Kevin Grittner wrote: Bruce Momjian br...@momjian.us wrote: Kevin Grittner wrote: Did you mean to say that journaled file systems are *not* necessary? Yes, not needed for database reliablity. The patch text was attached; was it unclear? I think you accidentally left out the

Re: [HACKERS] WAL documentation changes

2008-12-17 Thread Tatsuo Ishii
Bruce, In your document change which one can be placed on non-journalling file system? data? wal? or both? For me it seems it's not clear. -- Tatsuo Ishii SRA OSS, Inc. Japan Josh Berkus wrote: First, none of the general purpose filesystems I've seen so far do data journalling per

Re: [HACKERS] WAL documentation changes

2008-12-15 Thread Bruce Momjian
Josh Berkus wrote: First, none of the general purpose filesystems I've seen so far do data journalling per default, since it's a huge performance penalty, even for non-RDBMS workloads. The feature you talk about is ext3 specific (and should be pointed out as such) and only disables write

Re: [HACKERS] WAL documentation changes

2008-12-10 Thread Bruce Momjian
Michael Renner wrote: Hi, the comment WRT WAL recovery and FS journals [1] is a bit misleading in it's current form. First, none of the general purpose filesystems I've seen so far do data journalling per default, since it's a huge performance penalty, even for non-RDBMS workloads. The

Re: [HACKERS] WAL documentation changes

2008-12-10 Thread Josh Berkus
First, none of the general purpose filesystems I've seen so far do data journalling per default, since it's a huge performance penalty, even for non-RDBMS workloads. The feature you talk about is ext3 specific (and should be pointed out as such) and only disables write ordering, meaning that

Re: [HACKERS] WAL documentation

2001-01-24 Thread Bruce Momjian
The WAL logs auto-delete I think. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup.| Drexel Hill, Pennsylvania 19026

RE: [HACKERS] WAL documentation

2001-01-24 Thread Mikheev, Vadim
The WAL logs auto-delete I think. At checkpoint time. Vadim

RE: [HACKERS] WAL documentation

2001-01-24 Thread Mikheev, Vadim
1) In the 'WAL Parameters' section, paragraph 3 there is the following sentence: "After a checkpoint has been made, any log segments written before the redo record may be removed/archived..." What does the 'may' refer mean? Does the database administrator need to go into the directory and

Re: [HACKERS] WAL documentation

2001-01-24 Thread Oliver Elphick
Here's a patch to the wal.sgml text to take acocunt of Vadim's explanations. *** wal.sgml.orig Wed Jan 24 21:55:56 2001 --- wal.sgml Wed Jan 24 22:08:44 2001 *** *** 149,154 --- 149,176 /Sect1 + Sect1 id="recovery" + TitleDatabase Recovery with WAL/Title + +

Re: [HACKERS] WAL documentation

2001-01-24 Thread Peter Eisentraut
Oliver Elphick writes: Here's a patch to the wal.sgml text to take acocunt of Vadim's explanations. I checked in your documentation plus some fixes at other places. Does somebody care to submit some new words to describe the fsync option

Re: [HACKERS] WAL documentation

2001-01-23 Thread Barry Lind
Not knowing much about WAL, but understanding a good deal about Oracle's logs, I read the WAL documentation below. While it is good, after reading it I am still left with a couple of questions and therefore believe the doc could be improved a bit. The two questions I am left with after reading

RE: [HACKERS] WAL documentation

2001-01-23 Thread Christopher Kings-Lynne
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Barry Lind Sent: Wednesday, January 24, 2001 12:32 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] WAL documentation Not knowing much about WAL, but understanding a good deal about