[DOCS] Updated documentation for new sequence binding

2005-10-02 Thread Bruce Momjian 
I have marged Tom's description of the new sequence binding with text I
was working on.  I modified it to follow the existing "we used to do X,
now we do Y" pattern in the surrounding entries:

http://candle.pha.pa.us/tmp/pgsql/release.html#RELEASE-8-1

I also added an SQL query that will show and update a pre-8.1 loaded
schema to the new oid-based sequence storage use.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [email protected]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [DOCS] Updated documentation for new sequence binding

2005-10-02 Thread Bruce Momjian 
pgman wrote:
> I have marged Tom's description of the new sequence binding with text I
> was working on.  I modified it to follow the existing "we used to do X,
> now we do Y" pattern in the surrounding entries:
> 
>   http://candle.pha.pa.us/tmp/pgsql/release.html#RELEASE-8-1

Sorry, this is a better URL:


http://candle.pha.pa.us/main/writings/pgsql/sgml/release.html#RELEASE-8-1

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [email protected]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] [DOCS] Added documentation about caching, reliability

2005-10-02 Thread Jonah H. Harris 
IMHO, spelling out each one is redundant... the first one "Write-Ahead
Logging (WAL)" seems to define WAL for use later in the text.
On 9/28/05, Bruce Momjian  wrote:
Alvaro Herrera wrote:> On Wed, Sep 28, 2005 at 02:26:24PM -0400, Bruce Momjian wrote:> > I have added a section to the top of the WAL docs explaining caching and> > reliability issues:> >
> > http://candle.pha.pa.us/main/writings/pgsql/sgml/reliability.html> >> > I also renamed the chapter "Reilability" rather than "WAL."
>> While you are re-titling the docs, maybe the sections on that chapter> could be titled "Benefits of Write-Ahead Log" instead of "Benefits of> WAL", etc.The chapter sections are:
Table of Contents26.1. Write-Ahead Logging (WAL)26.2. Benefits of WAL26.3. WAL Configuration26.4. WAL InternalsAre you suggesting we spell out Write-Ahead Logging for all section
titles?--  Bruce
Momjian|  http://candle.pha.pa.us  [email protected]  
|  (610) 359-1001  +  If your life is a hard drive, |  13 Roberts Road  +  Christ
can be your
backup.|  Newtown
Square, Pennsylvania 19073---(end of broadcast)---TIP 1: if posting/reading through Usenet, please send an appropriate   subscribe-nomail command to 
[EMAIL PROTECTED] so that your   message can get through to the mailing list cleanly-- Respectfully,Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [DOCS] [HACKERS] Added documentation about caching, reliability

2005-10-02 Thread Jonah H. Harris 
Hey Bruce,

One grammar issue... otherwise great work.

 they can be moved to another computer with
   similar hardware and all committed transaction will remain intact.

should be

 they can be moved to another computer with
   similar hardware and all committed transactions will remain intact.On 9/28/05, Bruce Momjian  wrote:I have added a section to the top of the WAL docs explaining caching and
reliability issues:http://candle.pha.pa.us/main/writings/pgsql/sgml/reliability.htmlI also renamed the chapter "Reilability" rather than "WAL."
--  Bruce
Momjian|  http://candle.pha.pa.us  [email protected]  
|  (610) 359-1001  +  If your life is a hard drive, |  13 Roberts Road  +  Christ
can be your
backup.|  Newtown
Square, Pennsylvania 19073---(end of broadcast)---TIP 1: if posting/reading through Usenet, please send an appropriate   subscribe-nomail command to 
[EMAIL PROTECTED] so that your   message can get through to the mailing list cleanly-- Respectfully,Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporationhttp://www.enterprisedb.com/