Re: non-WAL btree?
| От | Alex Vinogradovs |
|---|---|
| Тема | Re: non-WAL btree? |
| Дата | |
| Msg-id | 1217623000.79373.59.camel@localhost обсуждение исходный текст |
| Ответ на | Re: non-WAL btree? ("David Wilson" <david.t.wilson@gmail.com>) |
| Ответы |
Re: non-WAL btree?
Re: non-WAL btree? |
| Список | 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 по дате отправления: