Re: non-WAL btree?

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: non-WAL btree?
Дата
Msg-id ead3b0cfd7c4e934e24e601b706e9355@stringsutils.com
обсуждение исходный текст
Ответ на Re: non-WAL btree?  (Alex Vinogradovs <AVinogradovs@Clearpathnet.com>)
Список pgsql-general
On 4:36 pm 08/01/08 Alex Vinogradovs <AVinogradovs@Clearpathnet.com> wrote:
> It's not that I expect a lot of improvement by having non-WAL
> indexing

Have you tried using a fill factor less than 90%?
That is on my list of things to test, but have not done yet.. In particular
you need to find a balance where the speed gained justifies the increase in
size of the index.. and the potential slowdowns because of larger indexes.


В списке pgsql-general по дате отправления:

Предыдущее
От: Alex Vinogradovs
Дата:
Сообщение: Re: non-WAL btree?
Следующее
От: "Jaime Casanova"
Дата:
Сообщение: Re: non-WAL btree?