| From: | Glen Parker <glenebob(at)nwlink(dot)com> |
|---|---|
| To: | Postgres General <pgsql-general(at)postgresql(dot)org> |
| Cc: | Jeremy Harris <jgh(at)wizmail(dot)org> |
| Subject: | Re: I don't want to back up index files |
| Date: | 2009-03-13 20:48:48 |
| Message-ID: | 49BAC6B0.5030701@nwlink.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jeremy Harris wrote:
> Simon Riggs wrote:
>> The idea of auto rebuilding indexes following recovery has already been
>> proposed, so is under consideration. It hasn't been proposed in relation
>> to the use case you mention, so that is new.
>>
>> If we did as you suggest then it would speed up the base backup but
>> would also add index rebuild time onto the end of any recovery.
>
> Forgive me for being stupid, but isn't a time when all the data for
> a table is being streamed in, during restore, the *perfect* time
> to build an index? Why wait until after the restore?
Not all the data streams in. Most of it is there before the WAL replay
begins.
-Glen
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2009-03-13 21:13:41 | Re: recatalog existing databases after re-build from source |
| Previous Message | Tom Lane | 2009-03-13 20:20:05 | Re: Inserting string with a " into an array using {} syntax ... possible? |