Re: Draft release notes

Simon Riggs wrote:
> On Thu, 2006-09-14 at 01:12 -0400, Bruce Momjian wrote:
> > Here is an early draft of the release notes.  It needs more polish and
> > review:
> > 
> >     http://momjian.us/cgi-bin/pgrelease
> > 
> > I will catch up on my email tomorrow, update the open items list for
> > 8.2, and then return to the release notes for cleanup.
> 
> A few changes:
> 
> - Improve COPY performance (Alon Goldshuv)
> - Optimize the locking used by sequential scans (Qingqing Zhou)
> 
> - Re-enable full_page_writes (Tom) 
> This flag can now be used even with PITR. It is turned **on** (not off!)
> automatically between pg_start_backup() and pg_stop_backup() calls.
> 
> - Add support for forcing a switch to a new xlog file (Simon Riggs) 
> ...should include Tom

OK, done.

> 
> - Improve performance of replaying WAL logs on a backup server (Simon
> Riggs) 
> ...I describe this as Restartable Recovery... don't think it improves
> performance exactly, just avoids needing to re-run it from scratch

OK, new wording:
* Allow WAL replay to be restared quicker in case of a crash (Simon  Riggs)  The improvement is to do periodic
checkpointsduring WAL recovery, so  if there is a crash, future WAL recovery is shortened.
 

> My memory says this was eventually removed, even though it was committed
> for a time. Am I wrong?
> - Make EXPLAIN sampling smarter, to avoid excessive sampling delay
> (Martijn van Oosterhout)

I see a reversion for EXPLAIN ANALYZE only:
date: 2006/06/09 19:30:56;  author: tgl;  state: Exp;  lines: +27 -172Revert sampling patch for EXPLAIN ANALYZE; it
turnsout to be toounreliable because node timing is much less predictable than the patchexpects.  I kept the API change
forInstrStopNode, however.
 

so the item is probably still OK.

--  Bruce Momjian   bruce@momjian.us EnterpriseDB    http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +