
WAL was a difficult feature to add to 7.1.  Currently, it is only used
as a performance benefit, but I expect it will be used in the future to
add new features like:

	Advanced Replication
	Point-in-time recovery
	Row reuse without vacuum

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 27 Apr 2001 17:03:56 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
WAL feature
On Fri, 27 Apr 2001, Bruce Momjian wrote:

>
> WAL was a difficult feature to add to 7.1.  Currently, it is only used
> as a performance benefit, but I expect it will be used in the future to
> add new features like:
>
> 	Advanced Replication

How?

> 	Point-in-time recovery

I thought that was understood from Vadim's explanations?

> 	Row reuse without vacuum

How?  Didn't even see these as being related ...


Fri, 27 Apr 2001 18:58:30 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: WAL feature
> On Fri, 27 Apr 2001, Bruce Momjian wrote:
> 
> >
> > WAL was a difficult feature to add to 7.1.  Currently, it is only used
> > as a performance benefit, but I expect it will be used in the future to
> > add new features like:
> >
> > 	Advanced Replication
> 
> How?

I guess other hosts could read the WAL to find out what changed.

> 
> > 	Point-in-time recovery
> 
> I thought that was understood from Vadim's explanations?

Yes, I am just reiterating that WAL may be related to future new
features.

> 
> > 	Row reuse without vacuum
> 
> How?  Didn't even see these as being related ...

It may be.  Not sure.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 27 Apr 2001 18:16:28 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: WAL feature
On Fri, 27 Apr 2001, Bruce Momjian wrote:

> > How?
>
> I guess other hosts could read the WAL to find out what changed.

I wonder if that would get around one of the issues I had brought up a
ways back concerning replication and stuff like sequences ...

> > > 	Row reuse without vacuum
> >
> > How?  Didn't even see these as being related ...
>
> It may be.  Not sure.

Neither am I ... Vadim seems to think so, so am curious as to how ...



Fri, 27 Apr 2001 20:14:55 -0300 (ADT)
The Hermit Hacker <scrappy@hub.org>
Re: WAL feature
> On Fri, 27 Apr 2001, Bruce Momjian wrote:
> 
> > > How?
> >
> > I guess other hosts could read the WAL to find out what changed.
> 
> I wonder if that would get around one of the issues I had brought up a
> ways back concerning replication and stuff like sequences ...

Yep, WAL collects all database changes into one file.  Easy to see how
some other host trying to replication a different host would find the
WAL contents valuable.

> 
> > > > 	Row reuse without vacuum
> > >
> > > How?  Didn't even see these as being related ...
> >
> > It may be.  Not sure.
> 
> Neither am I ... Vadim seems to think so, so am curious as to how ...

I think my point is that WAL could prove to be very valuable in a number
of areas, perhaps more areas than we know of right now.  In fact, I
think one idea once we start 7.2 is to identify how we want to use WAL
in the upcoming 7.2 features, make any needed WAL improvements, then
start adding features.

WAL was tough to add, but there are probably a lot of nice things was
can do now that we have it.

Also, Vadim mentioned that WAL fixed btree corruption problems, which
was certainly important too.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Fri, 27 Apr 2001 19:20:02 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: WAL feature
What about incremental backup ?


"Bruce Momjian" <pgman@candle.pha.pa.us> �������/�������� � ��������
���������: news:200104272103.f3RL3ur23234@candle.pha.pa.us...
>
> WAL was a difficult feature to add to 7.1.  Currently, it is only used
> as a performance benefit, but I expect it will be used in the future to
> add new features like:
>
> Advanced Replication
> Point-in-time recovery
> Row reuse without vacuum
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl



Sat, 28 Apr 2001 12:59:42 +0400
"Sergey E. Volkov" <sve@raiden.bancorp.ru>
Re: WAL feature