Re: Fast index build vs. PITR - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Fast index build vs. PITR
Date
Msg-id 14278.1086056115@sss.pgh.pa.us
Whole thread Raw
In response to Re: Fast index build vs. PITR  (Gavin Sherry <swm@linuxworld.com.au>)
List pgsql-hackers
Gavin Sherry <swm@linuxworld.com.au> writes:
>> So AFAICS, we've got to dump the index contents into WAL to support
>> PITR.  This is a tad annoying.

> Is it possible in this case to dump the index block by block into the log
> after it has been generated?

That's what we do now, and it more or less doubles the amount of I/O
needed to create an index ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fast index build vs. PITR
Next
From: Bruce Momjian
Date:
Subject: Re: Fast index build vs. PITR