Greg Stark <gsstark(at)mit(dot)edu> writes:
> I'm not clear that building from WAL is really going to be that much faster.
> A) algorithmically it's only the factor of log(n) that you're talking about.
> and B) the WAL will have records for every write, not just the final product,
> so it might potentially have a lot more writes to do.

Wrong ... what we log in WAL for a btree index build is just the series
of completed index page images.  Recreation of the index would proceed
at whatever your disk read/write bandwidth is.

Like Alvaro, I suspect that people who are using PITR will be concerned
about recovery time, and would not be thrilled with any scenario that
involves REINDEX to get the system back on its feet.

			regards, tom lane

In response to

• Re: Fast index build vs. PITR at 2004-06-01 17:55:38 from Greg Stark

Responses

• Re: Fast index build vs. PITR at 2004-06-01 20:17:13 from Bruce Momjian

pgsql-hackers by date

Next:	From: Matthew T. O'Connor	Date: 2004-06-01 19:30:08
	Subject: Re: Official Freeze Date for 7.5: July 1st, 2004
Previous:	From: Alvaro Herrera	Date: 2004-06-01 19:17:58
	Subject: Re: Fast index build vs. PITR