Re: non-WAL btree? - Mailing list pgsql-general

From Alex Vinogradovs
Subject Re: non-WAL btree?
Date
Msg-id 1217623000.79373.59.camel@localhost
Whole thread Raw
In response to Re: non-WAL btree?  ("David Wilson" <david.t.wilson@gmail.com>)
Responses Re: non-WAL btree?  ("Francisco Reyes" <lists@stringsutils.com>)
Re: non-WAL btree?  ("Jaime Casanova" <jcasanov@systemguards.com.ec>)
List pgsql-general
It's not that I expect a lot of improvement by having non-WAL
indexing, it just sounds logical to me to have that, since
index can be re-created fast enough during recovery, and it
would reduce my IO to some extent.

Alex.

> Sorry, as I hit send, I realized I should clarify this: I do my bulk
> loads with the indexes active; I don't rebuild them (as they're
> necessary during the batch calculations). Dropping the indexes and
> using test data didn't show a significant performance improvement over
> leaving the indexes enabled.
>

pgsql-general by date:

Previous
From: Alex Vinogradovs
Date:
Subject: Re: non-WAL btree?
Next
From: "Francisco Reyes"
Date:
Subject: Re: non-WAL btree?