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

From Francisco Reyes
Subject Re: non-WAL btree?
Date
Msg-id ead3b0cfd7c4e934e24e601b706e9355@stringsutils.com
Whole thread Raw
In response to Re: non-WAL btree?  (Alex Vinogradovs <AVinogradovs@Clearpathnet.com>)
List 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 by date:

Previous
From: Alex Vinogradovs
Date:
Subject: Re: non-WAL btree?
Next
From: "Jaime Casanova"
Date:
Subject: Re: non-WAL btree?